/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * JInternalFrameSalesBill.java
 *
 * Created on Dec 4, 2011, 6:36:24 PM
 */
package callcenter;
import Database.Addministave;
import Database.Customer;
import Database.DetailSalesBill;
import Database.Product;
import Database.SalesBill;
import java.awt.Color;
import java.io.File;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.DefaultComboBoxModel;
import java.util.Locale;
import java.util.ResourceBundle;
import javax.swing.ImageIcon;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.border.TitledBorder;
import javax.swing.table.DefaultTableModel;
import sun.util.calendar.JulianCalendar;
import Util.*;
/**
 *
 * @author user
 */
public class JInternalFrameSalesBill extends javax.swing.JInternalFrame {
    Vector<Customer> ctl=new Vector<Customer> ();
     Vector<Customer> ctl2=new Vector<Customer> (); 
    Vector<Addministave> adl=new Vector<Addministave> (); 
    Vector<Product> pdl=new Vector<Product> (); 
     Vector<Product> pdl1=new Vector<Product> (); 
     Vector<Product> pdl2=new Vector<Product> (); 
    Vector<SalesBill> lsbb=new Vector<SalesBill> (); 
    Vector<DetailSalesBill> vtdt=new Vector<DetailSalesBill> (); 
    //private int b = Medium.jfl.Number();
    private String langue = new String();
    private String country = new String();
    private String str = new String();
    private Locale lc = null;
    private ResourceBundle rb = null;
    private  File f = new File("."); 
    /** Creates new form JInternalFrameSalesBill */
    public JInternalFrameSalesBill() {
        Medium.jifs = this;
        initComponents();
        Createcb();
        Createcbad();
        
        Createctmersearch();
        SalesBill sb=new SalesBill();
        if(sb.geti()>=4)
        {
        jButton6.setEnabled(true);
        int i=4;
       Creattabledatabase1(i);
       System.out.println("1"+sb.geti());
        }
        else
        {
            Creattabledatabase22(sb.geti());
            jButton6.setEnabled(false);
        }
       jComboBoxProductname.setEnabled(false);
       jButton7.setEnabled(false);
       jTabbedPane2.setVisible(false);
       //jPanel97.setEnabled(false);
       createpd();
//       jButton16.setEnabled(false);
       jButton3.setEnabled(false);
       jButton2.setEnabled(false);
       jLabel10.setText("Pages 1");
       jComboBoxctmsearch.setEnabled(false);
       jButton5.setEnabled(false);
       jButton2.setEnabled(false);
       jButton3.setEnabled(false);
    }
    
  
    public void createpd()
    {
        Product pd=new Product();
        pdl=pd.Vectorproduct();
        DefaultComboBoxModel dc=new DefaultComboBoxModel();
        dc.setSelectedItem("Product Name....");
        for(Product pdd:pdl)
        {
            dc.addElement(pdd.getProductName());
            jComboBoxproductname22.setModel(dc);
            
        }
    }
    public int getselectedsalesbillid()
    {
         String s=this.jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 0).toString();
         int billid=Integer.valueOf(s) ;
         return billid;
         //return 0;
    }
     public int prdid()
    {
          int index=jComboBoxProductname.getSelectedIndex();
            Product pr=new Product();
            pdl1=pr.Vectorproduct1();
            int productid=pdl1.get(index).getProductId();
            return productid;
    }
      public int prdid1()
    {
          int index=jComboBoxproductname22.getSelectedIndex();
            Product pr=new Product();
            pdl2=pr.Vectorproduct1();
            int productid=pdl2.get(index).getProductId();
            return productid;
    }
    public  void Creattabledatabase1(int i)
    {
        
        Vector<String> cols =new Vector<String>();
        cols.add("Bill Id");
        cols.add("Bill Name");
        cols.add("Customer");
        cols.add("Billing Person");
        cols.add("Build Date");
        cols.add("States");
        cols.add("Unit");
        cols.add("Total Cost");
        SalesBill sb=new SalesBill();
        Vector<Vector<Object>> listsalesbill1=new Vector<Vector<Object>>();
        for(int j=i-4; j<i;j++)
        {
        listsalesbill1.add( sb.Listtablesalesbill().elementAt(j));
        }
        DefaultTableModel dtb=new DefaultTableModel(listsalesbill1,cols)
       {

            @Override
            public boolean isCellEditable(int row, int column) {
                return false;
            }
            
        }; 
        this.jTablecontent.getTableHeader().setReorderingAllowed(false);
        jTablecontent.setModel(dtb);
    }
       public  void Creattabledatabase22(int i)
    {
        
        Vector<String> cols =new Vector<String>();
        cols.add("Bill Id");
        cols.add("Bill Name");
        cols.add("Customer");
        cols.add("Billing Person");
        cols.add("Build Date");
        cols.add("States");
        cols.add("Unit");
        cols.add("Total Cost");
        SalesBill sb=new SalesBill();
        Vector<Vector<Object>> listsalesbill1=new Vector<Vector<Object>>();
        for(int j=0; j<i;j++)
        {
        listsalesbill1.add( sb.Listtablesalesbill().elementAt(j));
        }
        DefaultTableModel dtb=new DefaultTableModel(listsalesbill1,cols)
       {

            @Override
            public boolean isCellEditable(int row, int column) {
                return false;
            }
            
        }; 
        this.jTablecontent.getTableHeader().setReorderingAllowed(false);
        jTablecontent.setModel(dtb);
    }
    private void Creattabledatabase2(int i)
    {
          Vector<String> cols =new Vector<String>();
        cols.add("Bill Id");
        cols.add("Bill Name");
        cols.add("Customer");
        cols.add("Billing Person");
        cols.add("Build Date");
        cols.add("States");
        cols.add("Unit");
        cols.add("Total Cost");
        SalesBill sb=new SalesBill();
        Vector<Vector<Object>> listsalesbill1=new Vector<Vector<Object>>();
        while(i<sb.geti())
        {
        listsalesbill1.add( sb.Listtablesalesbill().elementAt(i));
        i++;
        }
        DefaultTableModel dtb=new DefaultTableModel(listsalesbill1,cols)
                 {

            @Override
            public boolean isCellEditable(int row, int column) {
                return false;
            }
            
        }; 
        this.jTablecontent.getTableHeader().setReorderingAllowed(false);
        jTablecontent.setModel(dtb);
    }
     private void Creattabledatabasepr(int a)
    {
          Vector<String> cols =new Vector<String>();
        cols.add("Bill Id");
        cols.add("Bill Name");
        cols.add("Customer");
        cols.add("Billing Person");
        cols.add("Build Date");
        cols.add("States");
        cols.add("Unit");
        cols.add("Total Cost");
        SalesBill sb=new SalesBill();
        Vector<Vector<Object>> listsalesbill1=new Vector<Vector<Object>>();
       for(int b=a-4;b<a;b++)
        {
        listsalesbill1.add( sb.Listtablesalesbill().elementAt(b));
        }
       
        DefaultTableModel dtb=new DefaultTableModel(listsalesbill1,cols)
                 {

            @Override
            public boolean isCellEditable(int row, int column) {
                return false;
            }
            
        }; 
        this.jTablecontent.getTableHeader().setReorderingAllowed(false);
         jTablecontent.setModel(dtb);
    }
    private void Creattabledatabase()
    {
        Vector<String> cols =new Vector<String>();
        cols.add("Bill Id");
        cols.add("Bill Name");
        cols.add("Customer");
        cols.add("Billing Person");
        cols.add("Build Date");
        cols.add("States");
        cols.add("Unit");
        cols.add("Total Cost");
        SalesBill sb=new SalesBill();
        DefaultTableModel dtb=new DefaultTableModel(sb.Listtablesalesbill(),cols)
                 {

            @Override
            public boolean isCellEditable(int row, int column) {
                return false;
            }
            
        }; 
        this.jTablecontent.getTableHeader().setReorderingAllowed(false);
        jTablecontent.setModel(dtb);
    }
     private void Creattabledatabase3()
    {
        Vector<String> cols =new Vector<String>();
        cols.add("Bill Id");
        cols.add("Bill Name");
        cols.add("Customer");
        cols.add("Billing Person");
        cols.add("Build Date");
        cols.add("States");
        cols.add("Unit");
        cols.add("Total Cost");
        SalesBill sb=new SalesBill();
        DefaultTableModel dtb=new DefaultTableModel(null,cols)
                 {

            @Override
            public boolean isCellEditable(int row, int column) {
                return false;
            }
            
        }; 
        this.jTablecontent.getTableHeader().setReorderingAllowed(false);
        jTablecontent.setModel(dtb);
    }
    private void Createcb()
    {
        Customer ct=new Customer();
        ctl=ct.customerlist();  
        DefaultComboBoxModel dc=new DefaultComboBoxModel();
        dc.setSelectedItem("Select");
        for(Customer ctm:ctl)
        {
            dc.addElement(ctm.getCustomername());
            jComboBoxcustomername.setModel(dc);
            
        }
        
    }
     private void Createctmersearch()
    {
        Customer ct=new Customer();
        ctl2=ct.customerlist();  
        DefaultComboBoxModel dc=new DefaultComboBoxModel();
        dc.setSelectedItem("Select");
        for(Customer ctm:ctl2)
        {
            dc.addElement(ctm.getCustomername());
            jComboBoxctmsearch.setModel(dc);
            
        }
        
    }
    
    private void Createcbpd()
    {
        Product pd=new Product();
        pd.setUnit(jComboBoxunit.getSelectedItem().toString());
        pdl=pd.Vectorproduct();
        DefaultComboBoxModel dc=new DefaultComboBoxModel();
        dc.setSelectedItem("Select");
        for(Product pdd:pdl)
        {
            dc.addElement(pdd.getProductName());
            jComboBoxProductname.setModel(dc);
            
        }
    }
    public void Createcbad()
    {
        Addministave ad=new Addministave();
        adl=ad.Addlist();
        DefaultComboBoxModel ac=new DefaultComboBoxModel();
        ac.setSelectedItem("Select");
        for(Addministave add:adl)
        {
            ac.addElement(add.getAccountname());
            jComboBoxaccount.setModel(ac);
        }
    }
    public void Createcbst()
    {
       SalesBill sb=new SalesBill();
       lsbb=sb.lissb();
       DefaultComboBoxModel dc=new DefaultComboBoxModel();
       for(SalesBill s:lsbb)
       {
           dc.addElement(s.getState());
           jComboBoxst.setModel(dc);
       }
    }
    /*
      String username=this.jTablenoidung.getValueAt(jTablenoidung.getSelectedRow(), 0).toString();
        String password=this.jTablenoidung.getValueAt(jTablenoidung.getSelectedRow(), 1).toString();
        String hoten=this.jTablenoidung.getValueAt(jTablenoidung.getSelectedRow(), 2).toString();
        String quyen=this.jTablenoidung.getValueAt(jTablenoidung.getSelectedRow(), 3).toString();
     */
    private void Tableinformation()
    {
        try{
        String billname=this.jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 1).toString();
        String customername=this.jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 2).toString();
        String billpersion=this.jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 3).toString();
        String st=this.jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 5).toString();
        String unit=this.jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 6).toString();
        
        String date=this.jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 4).toString(); 
        //String date="03-23-2003";
        SimpleDateFormat sdf = new SimpleDateFormat("MM-dd-yyyy");
        this.jCalendarCombobuilddate.setDate(sdf.parse(date));
        
        this.jTextFieldbillname.setText(billname);
        this.jComboBoxcustomername.setSelectedItem(customername);
        this.jComboBoxaccount.setSelectedItem(billpersion);
        this.jComboBoxst.setSelectedItem(st);
        this.jComboBoxunit.setSelectedItem(unit);
        }
        catch(Exception ex)
        {
            System.out.println(ex);
        }
        // this.jComboBoxsstate.setSelectedItem(sstate);
    }
    private void Tableinformation1()
    {
        try{
        String billname=this.jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 1).toString();
        String customername=this.jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 2).toString();
        String billpersion=this.jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 3).toString();
        String st=this.jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 5).toString();
        String unit=this.jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 6).toString();
        
        String date=this.jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 4).toString(); 
        SimpleDateFormat sdf = new SimpleDateFormat("MM-dd-yyyy");
        this.jCalendarCombobuilddate.setDate(sdf.parse(date));
        
        this.jTextFieldbillname.setText(billname);
        this.jComboBoxcustomername.setSelectedItem(customername);
        this.jComboBoxaccount.setSelectedItem(billpersion);
        this.jComboBoxst.setSelectedItem(st);
        this.jComboBoxunit.setSelectedItem(unit);
        }
        catch(Exception ex)
        {
            System.out.println(ex);
        }
        // this.jComboBoxsstate.setSelectedItem(sstate);
    }
     private void Translate(String landue, String tenqg, String chuoi) {
        //callcenter/resources/JInternalFrameVender_en_US
        lc = new Locale(landue, tenqg);
        rb = ResourceBundle.getBundle("callcenter/resources/" + chuoi, lc);
        jTabbedPane1.setTitleAt(0, rb.getString("tab1"));
        jTabbedPane1.setTitleAt(1, rb.getString("tab2"));
        TitledBorder t = (TitledBorder) this.jPanel3.getBorder();
        t.setTitle(rb.getString("jPanel3.border.title"));
        jLabel1.setText(rb.getString("jLabel1.text"));
        jLabel2.setText(rb.getString("jLabel2.text"));
        jLabel3.setText(rb.getString("jLabel3.text"));
        jLabel4.setText(rb.getString("jLabel4.text"));
        jLabel5.setText(rb.getString("jLabel5.text"));
        //jButton1.setText(rb.getString("jButton1.text"));
        //jButtonadd.setText(rb.getString("jButton2.text"));
        //jButton3.setText(rb.getString("jButton3.text"));
        //jButton4.setText(rb.getString("jButton4.text"));
        jButton5.setText(rb.getString("jButton5.text"));
        TitledBorder t1 = (TitledBorder) this.jPanel1.getBorder();
        t1.setTitle(rb.getString("jPanel1.border.title"));
        jLabel6.setText(rb.getString("jLabel6.text"));
        jLabel7.setText(rb.getString("jLabel7.text"));
        jLabel8.setText(rb.getString("jLabel8.text"));
        //jLabel9.setText(rb.getString("jLabel9.text"));
        jCheckBoxsearchbillname.setText(rb.getString("jCheckBox1.text"));
        jCheckBoxsearchctomername.setText(rb.getString("jCheckBox2.text"));
        //jCheckBoxsearchbilldate.setText(rb.getString("jCheckBox3.setText"));
        TitledBorder t2 = (TitledBorder) this.jPanel4.getBorder();
        t2.setTitle(rb.getString("jPanel4.border.title"));
        
    }
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        jComboBox1 = new javax.swing.JComboBox();
        jTextField3 = new javax.swing.JTextField();
        jPanel75 = new javax.swing.JPanel();
        jPanel76 = new javax.swing.JPanel();
        jPanel14 = new javax.swing.JPanel();
        jPanel15 = new javax.swing.JPanel();
        jPanel23 = new javax.swing.JPanel();
        jPanel24 = new javax.swing.JPanel();
        jPanel25 = new javax.swing.JPanel();
        jPanel153 = new javax.swing.JPanel();
        buttonGroup1 = new javax.swing.ButtonGroup();
        jTabbedPane1 = new javax.swing.JTabbedPane();
        jPanel1 = new javax.swing.JPanel();
        jPanel3 = new javax.swing.JPanel();
        jPanel5 = new javax.swing.JPanel();
        jPanel6 = new javax.swing.JPanel();
        jPanel8 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        jPanel9 = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        jPanel10 = new javax.swing.JPanel();
        jLabel3 = new javax.swing.JLabel();
        jPanel11 = new javax.swing.JPanel();
        jLabel4 = new javax.swing.JLabel();
        jPanel12 = new javax.swing.JPanel();
        jLabel5 = new javax.swing.JLabel();
        jPanel16 = new javax.swing.JPanel();
        jLabel12 = new javax.swing.JLabel();
        jPanel17 = new javax.swing.JPanel();
        jPanel7 = new javax.swing.JPanel();
        jPanel18 = new javax.swing.JPanel();
        jTextFieldbillname = new javax.swing.JTextField();
        jPanel13 = new javax.swing.JPanel();
        jPanel159 = new javax.swing.JPanel();
        jComboBoxcustomername = new javax.swing.JComboBox();
        jPanel160 = new javax.swing.JPanel();
        jButton14 = new javax.swing.JButton();
        jPanel20 = new javax.swing.JPanel();
        jComboBoxaccount = new javax.swing.JComboBox();
        jPanel21 = new javax.swing.JPanel();
        jCalendarCombobuilddate = new org.freixas.jcalendar.JCalendarCombo();
        jPanel26 = new javax.swing.JPanel();
        jPanel89 = new javax.swing.JPanel();
        jComboBoxst = new javax.swing.JComboBox();
        jPanel90 = new javax.swing.JPanel();
        jComboBoxunit = new javax.swing.JComboBox();
        jPanel91 = new javax.swing.JPanel();
        jLabel13 = new javax.swing.JLabel();
        jPanel27 = new javax.swing.JPanel();
        jComboBoxProductname = new javax.swing.JComboBox();
        jPanel88 = new javax.swing.JPanel();
        jPanel19 = new javax.swing.JPanel();
        jButton1 = new javax.swing.JButton();
        jPanel22 = new javax.swing.JPanel();
        jPanel92 = new javax.swing.JPanel();
        jButton2 = new javax.swing.JButton();
        jPanel93 = new javax.swing.JPanel();
        jPanel94 = new javax.swing.JPanel();
        jButton3 = new javax.swing.JButton();
        jPanel95 = new javax.swing.JPanel();
        jButton4 = new javax.swing.JButton();
        jTabbedPane2 = new javax.swing.JTabbedPane();
        jPanel96 = new javax.swing.JPanel();
        jPanel98 = new javax.swing.JPanel();
        jPanel99 = new javax.swing.JPanel();
        jPanel100 = new javax.swing.JPanel();
        jPanel101 = new javax.swing.JPanel();
        jPanel102 = new javax.swing.JPanel();
        jPanel103 = new javax.swing.JPanel();
        jPanel104 = new javax.swing.JPanel();
        jPanel105 = new javax.swing.JPanel();
        jPanel106 = new javax.swing.JPanel();
        jLabel14 = new javax.swing.JLabel();
        jPanel107 = new javax.swing.JPanel();
        jLabel15 = new javax.swing.JLabel();
        jPanel108 = new javax.swing.JPanel();
        jLabel16 = new javax.swing.JLabel();
        jPanel109 = new javax.swing.JPanel();
        jPanel110 = new javax.swing.JPanel();
        jPanel111 = new javax.swing.JPanel();
        jLabel17 = new javax.swing.JLabel();
        jPanel112 = new javax.swing.JPanel();
        jPanel113 = new javax.swing.JPanel();
        jPanel114 = new javax.swing.JPanel();
        jTextFieldprice = new javax.swing.JTextField();
        jPanel115 = new javax.swing.JPanel();
        jTextFieldquantity = new javax.swing.JTextField();
        jPanel116 = new javax.swing.JPanel();
        jPanel117 = new javax.swing.JPanel();
        jLabel18 = new javax.swing.JLabel();
        jPanel118 = new javax.swing.JPanel();
        jTextFielddiscountrate = new javax.swing.JTextField();
        jPanel119 = new javax.swing.JPanel();
        jPanel120 = new javax.swing.JPanel();
        jPanel123 = new javax.swing.JPanel();
        jPanel124 = new javax.swing.JPanel();
        jButton12 = new javax.swing.JButton();
        jPanel125 = new javax.swing.JPanel();
        jButton13 = new javax.swing.JButton();
        jPanel126 = new javax.swing.JPanel();
        jPanel127 = new javax.swing.JPanel();
        jScrollPane3 = new javax.swing.JScrollPane();
        jTextAreadesription = new javax.swing.JTextArea();
        jPanel97 = new javax.swing.JPanel();
        jPanel128 = new javax.swing.JPanel();
        jLabel19 = new javax.swing.JLabel();
        jPanel129 = new javax.swing.JPanel();
        jScrollPane4 = new javax.swing.JScrollPane();
        jTableeditsalesbill2 = new javax.swing.JTable();
        jPanel130 = new javax.swing.JPanel();
        jPanel131 = new javax.swing.JPanel();
        jPanel136 = new javax.swing.JPanel();
        jPanel139 = new javax.swing.JPanel();
        jLabel21 = new javax.swing.JLabel();
        jPanel140 = new javax.swing.JPanel();
        jLabel22 = new javax.swing.JLabel();
        jPanel137 = new javax.swing.JPanel();
        jPanel141 = new javax.swing.JPanel();
        jLabel23 = new javax.swing.JLabel();
        jPanel142 = new javax.swing.JPanel();
        jLabel20 = new javax.swing.JLabel();
        jPanel138 = new javax.swing.JPanel();
        jPanel147 = new javax.swing.JPanel();
        jLabel9 = new javax.swing.JLabel();
        jPanel132 = new javax.swing.JPanel();
        jPanel133 = new javax.swing.JPanel();
        jPanel143 = new javax.swing.JPanel();
        jComboBoxproductname22 = new javax.swing.JComboBox();
        jPanel144 = new javax.swing.JPanel();
        jTextFieldprice2 = new javax.swing.JTextField();
        jPanel134 = new javax.swing.JPanel();
        jPanel145 = new javax.swing.JPanel();
        jTextFieldquantity2 = new javax.swing.JTextField();
        jPanel146 = new javax.swing.JPanel();
        jPanel148 = new javax.swing.JPanel();
        jLabel24 = new javax.swing.JLabel();
        jPanel149 = new javax.swing.JPanel();
        jTextFielddcountrate2 = new javax.swing.JTextField();
        jPanel135 = new javax.swing.JPanel();
        jScrollPane5 = new javax.swing.JScrollPane();
        jTextAreadescription = new javax.swing.JTextArea();
        jPanel161 = new javax.swing.JPanel();
        jPanel162 = new javax.swing.JPanel();
        jPanel122 = new javax.swing.JPanel();
        jPanel167 = new javax.swing.JPanel();
        jLabel26 = new javax.swing.JLabel();
        jPanel168 = new javax.swing.JPanel();
        jLabel27 = new javax.swing.JLabel();
        jPanel169 = new javax.swing.JPanel();
        jLabel28 = new javax.swing.JLabel();
        jPanel170 = new javax.swing.JPanel();
        jLabel29 = new javax.swing.JLabel();
        jPanel171 = new javax.swing.JPanel();
        jLabel30 = new javax.swing.JLabel();
        jPanel163 = new javax.swing.JPanel();
        jPanel164 = new javax.swing.JPanel();
        jPanel165 = new javax.swing.JPanel();
        jPanel121 = new javax.swing.JPanel();
        jPanel172 = new javax.swing.JPanel();
        jTextFieldctmname = new javax.swing.JTextField();
        jPanel173 = new javax.swing.JPanel();
        jTextFieldadress = new javax.swing.JTextField();
        jPanel174 = new javax.swing.JPanel();
        jTextFieldphone = new javax.swing.JTextField();
        jPanel175 = new javax.swing.JPanel();
        jTextFieldemail = new javax.swing.JTextField();
        jPanel176 = new javax.swing.JPanel();
        jPanel177 = new javax.swing.JPanel();
        jPanel179 = new javax.swing.JPanel();
        jLabel31 = new javax.swing.JLabel();
        jPanel180 = new javax.swing.JPanel();
        jComboBoxcustmtype = new javax.swing.JComboBox();
        jPanel178 = new javax.swing.JPanel();
        jComboBoxgender = new javax.swing.JComboBox();
        jPanel166 = new javax.swing.JPanel();
        jPanel181 = new javax.swing.JPanel();
        jPanel182 = new javax.swing.JPanel();
        jPanel183 = new javax.swing.JPanel();
        jLabel32 = new javax.swing.JLabel();
        jPanel184 = new javax.swing.JPanel();
        jPanel186 = new javax.swing.JPanel();
        jButton17 = new javax.swing.JButton();
        jPanel187 = new javax.swing.JPanel();
        jButton18 = new javax.swing.JButton();
        jPanel185 = new javax.swing.JPanel();
        jScrollPane6 = new javax.swing.JScrollPane();
        jTextAreadription = new javax.swing.JTextArea();
        jPanel4 = new javax.swing.JPanel();
        jPanel64 = new javax.swing.JPanel();
        jPanel66 = new javax.swing.JPanel();
        jPanel67 = new javax.swing.JPanel();
        jPanel74 = new javax.swing.JPanel();
        jLabel10 = new javax.swing.JLabel();
        jPanel68 = new javax.swing.JPanel();
        jPanel69 = new javax.swing.JPanel();
        jButton6 = new javax.swing.JButton();
        jPanel70 = new javax.swing.JPanel();
        jButton8 = new javax.swing.JButton();
        jPanel71 = new javax.swing.JPanel();
        jPanel72 = new javax.swing.JPanel();
        jButton7 = new javax.swing.JButton();
        jPanel73 = new javax.swing.JPanel();
        jTextField6 = new javax.swing.JTextField();
        jPanel65 = new javax.swing.JPanel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTablecontent = new javax.swing.JTable();
        jButton15 = new javax.swing.JButton();
        jPanel2 = new javax.swing.JPanel();
        jPanel33 = new javax.swing.JPanel();
        jPanel35 = new javax.swing.JPanel();
        jPanel36 = new javax.swing.JPanel();
        jPanel37 = new javax.swing.JPanel();
        jPanel28 = new javax.swing.JPanel();
        jPanel31 = new javax.swing.JPanel();
        jPanel32 = new javax.swing.JPanel();
        jPanel38 = new javax.swing.JPanel();
        jLabel7 = new javax.swing.JLabel();
        jPanel39 = new javax.swing.JPanel();
        jLabel8 = new javax.swing.JLabel();
        jPanel40 = new javax.swing.JPanel();
        jPanel41 = new javax.swing.JPanel();
        jPanel42 = new javax.swing.JPanel();
        jPanel43 = new javax.swing.JPanel();
        jPanel29 = new javax.swing.JPanel();
        jPanel52 = new javax.swing.JPanel();
        jPanel53 = new javax.swing.JPanel();
        jPanel54 = new javax.swing.JPanel();
        jCheckBoxsearchbillname = new javax.swing.JCheckBox();
        jPanel55 = new javax.swing.JPanel();
        jCheckBoxsearchctomername = new javax.swing.JCheckBox();
        jPanel56 = new javax.swing.JPanel();
        jPanel57 = new javax.swing.JPanel();
        jPanel58 = new javax.swing.JPanel();
        jPanel59 = new javax.swing.JPanel();
        jPanel30 = new javax.swing.JPanel();
        jPanel44 = new javax.swing.JPanel();
        jLabel6 = new javax.swing.JLabel();
        jPanel45 = new javax.swing.JPanel();
        jPanel46 = new javax.swing.JPanel();
        jTextFieldsearchbillname = new javax.swing.JTextField();
        jPanel47 = new javax.swing.JPanel();
        jComboBoxctmsearch = new javax.swing.JComboBox();
        jPanel48 = new javax.swing.JPanel();
        jLabelero = new javax.swing.JLabel();
        jPanel49 = new javax.swing.JPanel();
        jPanel60 = new javax.swing.JPanel();
        jPanel61 = new javax.swing.JPanel();
        jPanel62 = new javax.swing.JPanel();
        jButton5 = new javax.swing.JButton();
        jPanel63 = new javax.swing.JPanel();
        jPanel50 = new javax.swing.JPanel();
        jPanel51 = new javax.swing.JPanel();
        jPanel34 = new javax.swing.JPanel();
        jPanel77 = new javax.swing.JPanel();
        jPanel79 = new javax.swing.JPanel();
        jPanel80 = new javax.swing.JPanel();
        jPanel87 = new javax.swing.JPanel();
        jLabel11 = new javax.swing.JLabel();
        jPanel81 = new javax.swing.JPanel();
        jPanel82 = new javax.swing.JPanel();
        jButton9 = new javax.swing.JButton();
        jPanel83 = new javax.swing.JPanel();
        jButton11 = new javax.swing.JButton();
        jPanel84 = new javax.swing.JPanel();
        jPanel85 = new javax.swing.JPanel();
        jButton10 = new javax.swing.JButton();
        jPanel86 = new javax.swing.JPanel();
        jTextField7 = new javax.swing.JTextField();
        jPanel78 = new javax.swing.JPanel();
        jScrollPane2 = new javax.swing.JScrollPane();
        jTablesearchsalesbill = new javax.swing.JTable();

        jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
        jComboBox1.setName("jComboBox1"); // NOI18N

        org.jdesktop.application.ResourceMap resourceMap = org.jdesktop.application.Application.getInstance(callcenter.CallcenterApp.class).getContext().getResourceMap(JInternalFrameSalesBill.class);
        jTextField3.setText(resourceMap.getString("jTextField3.text")); // NOI18N
        jTextField3.setName("jTextField3"); // NOI18N

        jPanel75.setName("jPanel75"); // NOI18N

        javax.swing.GroupLayout jPanel75Layout = new javax.swing.GroupLayout(jPanel75);
        jPanel75.setLayout(jPanel75Layout);
        jPanel75Layout.setHorizontalGroup(
            jPanel75Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel75Layout.setVerticalGroup(
            jPanel75Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );

        jPanel76.setName("jPanel76"); // NOI18N

        javax.swing.GroupLayout jPanel76Layout = new javax.swing.GroupLayout(jPanel76);
        jPanel76.setLayout(jPanel76Layout);
        jPanel76Layout.setHorizontalGroup(
            jPanel76Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel76Layout.setVerticalGroup(
            jPanel76Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );

        jPanel14.setName("jPanel14"); // NOI18N

        javax.swing.GroupLayout jPanel14Layout = new javax.swing.GroupLayout(jPanel14);
        jPanel14.setLayout(jPanel14Layout);
        jPanel14Layout.setHorizontalGroup(
            jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel14Layout.setVerticalGroup(
            jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );

        jPanel15.setName("jPanel15"); // NOI18N

        javax.swing.GroupLayout jPanel15Layout = new javax.swing.GroupLayout(jPanel15);
        jPanel15.setLayout(jPanel15Layout);
        jPanel15Layout.setHorizontalGroup(
            jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel15Layout.setVerticalGroup(
            jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );

        jPanel23.setName("jPanel23"); // NOI18N

        javax.swing.GroupLayout jPanel23Layout = new javax.swing.GroupLayout(jPanel23);
        jPanel23.setLayout(jPanel23Layout);
        jPanel23Layout.setHorizontalGroup(
            jPanel23Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel23Layout.setVerticalGroup(
            jPanel23Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );

        jPanel24.setName("jPanel24"); // NOI18N

        javax.swing.GroupLayout jPanel24Layout = new javax.swing.GroupLayout(jPanel24);
        jPanel24.setLayout(jPanel24Layout);
        jPanel24Layout.setHorizontalGroup(
            jPanel24Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel24Layout.setVerticalGroup(
            jPanel24Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );

        jPanel25.setName("jPanel25"); // NOI18N

        javax.swing.GroupLayout jPanel25Layout = new javax.swing.GroupLayout(jPanel25);
        jPanel25.setLayout(jPanel25Layout);
        jPanel25Layout.setHorizontalGroup(
            jPanel25Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel25Layout.setVerticalGroup(
            jPanel25Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );

        jPanel153.setName("jPanel153"); // NOI18N

        javax.swing.GroupLayout jPanel153Layout = new javax.swing.GroupLayout(jPanel153);
        jPanel153.setLayout(jPanel153Layout);
        jPanel153Layout.setHorizontalGroup(
            jPanel153Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel153Layout.setVerticalGroup(
            jPanel153Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );

        setClosable(true);
        setIconifiable(true);
        setMaximizable(true);
        setTitle(resourceMap.getString("Form.title")); // NOI18N
        setFrameIcon(resourceMap.getIcon("Form.frameIcon")); // NOI18N
        setName("Form"); // NOI18N
        setPreferredSize(new java.awt.Dimension(970, 520));

        jTabbedPane1.setName("jTabbedPane1"); // NOI18N

        jPanel1.setName("jPanel1"); // NOI18N
        jPanel1.setLayout(new java.awt.GridLayout(2, 1, 3, 3));

        jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(resourceMap.getColor("jPanel3.border.border.lineColor"), 3), resourceMap.getString("jPanel3.border.title"))); // NOI18N
        jPanel3.setName("jPanel3"); // NOI18N
        jPanel3.setLayout(new java.awt.BorderLayout());

        jPanel5.setName("jPanel5"); // NOI18N
        jPanel5.setPreferredSize(new java.awt.Dimension(350, 198));
        jPanel5.setLayout(new java.awt.BorderLayout());

        jPanel6.setName("jPanel6"); // NOI18N
        jPanel6.setPreferredSize(new java.awt.Dimension(80, 198));
        jPanel6.setLayout(new java.awt.GridLayout(7, 1, 3, 3));

        jPanel8.setName("jPanel8"); // NOI18N
        jPanel8.setLayout(new java.awt.BorderLayout());

        jLabel1.setText(resourceMap.getString("jLabel1.text")); // NOI18N
        jLabel1.setName("jLabel1"); // NOI18N
        jPanel8.add(jLabel1, java.awt.BorderLayout.CENTER);

        jPanel6.add(jPanel8);

        jPanel9.setName("jPanel9"); // NOI18N
        jPanel9.setLayout(new java.awt.BorderLayout());

        jLabel2.setText(resourceMap.getString("jLabel2.text")); // NOI18N
        jLabel2.setName("jLabel2"); // NOI18N
        jPanel9.add(jLabel2, java.awt.BorderLayout.CENTER);

        jPanel6.add(jPanel9);

        jPanel10.setName("jPanel10"); // NOI18N
        jPanel10.setLayout(new java.awt.BorderLayout());

        jLabel3.setText(resourceMap.getString("jLabel3.text")); // NOI18N
        jLabel3.setName("jLabel3"); // NOI18N
        jPanel10.add(jLabel3, java.awt.BorderLayout.CENTER);

        jPanel6.add(jPanel10);

        jPanel11.setName("jPanel11"); // NOI18N
        jPanel11.setLayout(new java.awt.BorderLayout());

        jLabel4.setText(resourceMap.getString("jLabel4.text")); // NOI18N
        jLabel4.setName("jLabel4"); // NOI18N
        jPanel11.add(jLabel4, java.awt.BorderLayout.CENTER);

        jPanel6.add(jPanel11);

        jPanel12.setName("jPanel12"); // NOI18N
        jPanel12.setLayout(new java.awt.BorderLayout());

        jLabel5.setText(resourceMap.getString("jLabel5.text")); // NOI18N
        jLabel5.setName("jLabel5"); // NOI18N
        jPanel12.add(jLabel5, java.awt.BorderLayout.CENTER);

        jPanel6.add(jPanel12);

        jPanel16.setName("jPanel16"); // NOI18N
        jPanel16.setLayout(new java.awt.BorderLayout());

        jLabel12.setText(resourceMap.getString("jLabel12.text")); // NOI18N
        jLabel12.setName("jLabel12"); // NOI18N
        jPanel16.add(jLabel12, java.awt.BorderLayout.CENTER);

        jPanel6.add(jPanel16);

        jPanel17.setName("jPanel17"); // NOI18N
        jPanel17.setLayout(new java.awt.BorderLayout());
        jPanel6.add(jPanel17);

        jPanel5.add(jPanel6, java.awt.BorderLayout.LINE_START);

        jPanel7.setName("jPanel7"); // NOI18N
        jPanel7.setLayout(new java.awt.GridLayout(7, 1, 3, 3));

        jPanel18.setName("jPanel18"); // NOI18N
        jPanel18.setLayout(new java.awt.BorderLayout());

        jTextFieldbillname.setText(resourceMap.getString("jTextFieldbillname.text")); // NOI18N
        jTextFieldbillname.setName("jTextFieldbillname"); // NOI18N
        jTextFieldbillname.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTextFieldbillnameMouseClicked(evt);
            }
        });
        jTextFieldbillname.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jTextFieldbillnameActionPerformed(evt);
            }
        });
        jPanel18.add(jTextFieldbillname, java.awt.BorderLayout.CENTER);

        jPanel7.add(jPanel18);

        jPanel13.setName("jPanel13"); // NOI18N
        jPanel13.setLayout(new java.awt.BorderLayout());

        jPanel159.setName("jPanel159"); // NOI18N
        jPanel159.setPreferredSize(new java.awt.Dimension(140, 25));
        jPanel159.setLayout(new java.awt.BorderLayout());

        jComboBoxcustomername.setName("jComboBoxcustomername"); // NOI18N
        jComboBoxcustomername.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jComboBoxcustomernameActionPerformed(evt);
            }
        });
        jPanel159.add(jComboBoxcustomername, java.awt.BorderLayout.CENTER);

        jPanel13.add(jPanel159, java.awt.BorderLayout.LINE_START);

        jPanel160.setName("jPanel160"); // NOI18N
        jPanel160.setPreferredSize(new java.awt.Dimension(130, 25));
        jPanel160.setLayout(new java.awt.BorderLayout());

        jButton14.setIcon(resourceMap.getIcon("jButton14.icon")); // NOI18N
        jButton14.setText(resourceMap.getString("jButton14.text")); // NOI18N
        jButton14.setName("jButton14"); // NOI18N
        jButton14.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton14ActionPerformed(evt);
            }
        });
        jPanel160.add(jButton14, java.awt.BorderLayout.CENTER);

        jPanel13.add(jPanel160, java.awt.BorderLayout.LINE_END);

        jPanel7.add(jPanel13);

        jPanel20.setName("jPanel20"); // NOI18N
        jPanel20.setLayout(new java.awt.BorderLayout());

        jComboBoxaccount.setName("jComboBoxaccount"); // NOI18N
        jComboBoxaccount.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jComboBoxaccountActionPerformed(evt);
            }
        });
        jPanel20.add(jComboBoxaccount, java.awt.BorderLayout.CENTER);

        jPanel7.add(jPanel20);

        jPanel21.setName("jPanel21"); // NOI18N
        jPanel21.setLayout(new java.awt.BorderLayout());

        jCalendarCombobuilddate.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Select" }));
        jCalendarCombobuilddate.setName("jCalendarCombobuilddate"); // NOI18N
        jCalendarCombobuilddate.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jCalendarCombobuilddateActionPerformed(evt);
            }
        });
        jPanel21.add(jCalendarCombobuilddate, java.awt.BorderLayout.CENTER);

        jPanel7.add(jPanel21);

        jPanel26.setName("jPanel26"); // NOI18N
        jPanel26.setLayout(new java.awt.BorderLayout());

        jPanel89.setName("jPanel89"); // NOI18N
        jPanel89.setPreferredSize(new java.awt.Dimension(110, 25));
        jPanel89.setLayout(new java.awt.BorderLayout());

        jComboBoxst.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Select", "Paid", "Unpaid" }));
        jComboBoxst.setName("jComboBoxst"); // NOI18N
        jComboBoxst.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jComboBoxstActionPerformed(evt);
            }
        });
        jPanel89.add(jComboBoxst, java.awt.BorderLayout.CENTER);

        jPanel26.add(jPanel89, java.awt.BorderLayout.LINE_START);

        jPanel90.setName("jPanel90"); // NOI18N
        jPanel90.setPreferredSize(new java.awt.Dimension(110, 25));
        jPanel90.setLayout(new java.awt.BorderLayout());

        jComboBoxunit.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Select", "USD", "VND" }));
        jComboBoxunit.setName("jComboBoxunit"); // NOI18N
        jComboBoxunit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jComboBoxunitActionPerformed(evt);
            }
        });
        jPanel90.add(jComboBoxunit, java.awt.BorderLayout.CENTER);

        jPanel26.add(jPanel90, java.awt.BorderLayout.LINE_END);

        jPanel91.setName("jPanel91"); // NOI18N
        jPanel91.setLayout(new java.awt.BorderLayout());

        jLabel13.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel13.setText(resourceMap.getString("jLabel13.text")); // NOI18N
        jLabel13.setName("jLabel13"); // NOI18N
        jPanel91.add(jLabel13, java.awt.BorderLayout.CENTER);

        jPanel26.add(jPanel91, java.awt.BorderLayout.CENTER);

        jPanel7.add(jPanel26);

        jPanel27.setName("jPanel27"); // NOI18N
        jPanel27.setLayout(new java.awt.BorderLayout());

        jComboBoxProductname.setName("jComboBoxProductname"); // NOI18N
        jComboBoxProductname.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jComboBoxProductnameActionPerformed(evt);
            }
        });
        jPanel27.add(jComboBoxProductname, java.awt.BorderLayout.CENTER);

        jPanel7.add(jPanel27);

        jPanel88.setName("jPanel88"); // NOI18N
        jPanel88.setLayout(new java.awt.BorderLayout());

        jPanel19.setName("jPanel19"); // NOI18N
        jPanel19.setPreferredSize(new java.awt.Dimension(65, 65));
        jPanel19.setLayout(new java.awt.BorderLayout());

        jButton1.setIcon(resourceMap.getIcon("jButton1.icon")); // NOI18N
        jButton1.setText(resourceMap.getString("jButton1.text")); // NOI18N
        jButton1.setName("jButton1"); // NOI18N
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        jPanel19.add(jButton1, java.awt.BorderLayout.CENTER);

        jPanel88.add(jPanel19, java.awt.BorderLayout.LINE_START);

        jPanel22.setName("jPanel22"); // NOI18N
        jPanel22.setLayout(new java.awt.BorderLayout());

        jPanel92.setName("jPanel92"); // NOI18N
        jPanel92.setPreferredSize(new java.awt.Dimension(65, 65));
        jPanel92.setLayout(new java.awt.BorderLayout());

        jButton2.setIcon(resourceMap.getIcon("jButton2.icon")); // NOI18N
        jButton2.setText(resourceMap.getString("jButton2.text")); // NOI18N
        jButton2.setName("jButton2"); // NOI18N
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });
        jPanel92.add(jButton2, java.awt.BorderLayout.CENTER);

        jPanel22.add(jPanel92, java.awt.BorderLayout.LINE_START);

        jPanel93.setName("jPanel93"); // NOI18N
        jPanel93.setLayout(new java.awt.BorderLayout());

        jPanel94.setName("jPanel94"); // NOI18N
        jPanel94.setPreferredSize(new java.awt.Dimension(65, 25));
        jPanel94.setLayout(new java.awt.BorderLayout());

        jButton3.setIcon(resourceMap.getIcon("jButton3.icon")); // NOI18N
        jButton3.setText(resourceMap.getString("jButton3.text")); // NOI18N
        jButton3.setName("jButton3"); // NOI18N
        jButton3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton3ActionPerformed(evt);
            }
        });
        jPanel94.add(jButton3, java.awt.BorderLayout.CENTER);

        jPanel93.add(jPanel94, java.awt.BorderLayout.LINE_START);

        jPanel95.setName("jPanel95"); // NOI18N
        jPanel95.setLayout(new java.awt.BorderLayout());

        jButton4.setIcon(resourceMap.getIcon("jButton4.icon")); // NOI18N
        jButton4.setText(resourceMap.getString("jButton4.text")); // NOI18N
        jButton4.setName("jButton4"); // NOI18N
        jButton4.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton4ActionPerformed(evt);
            }
        });
        jPanel95.add(jButton4, java.awt.BorderLayout.CENTER);

        jPanel93.add(jPanel95, java.awt.BorderLayout.CENTER);

        jPanel22.add(jPanel93, java.awt.BorderLayout.CENTER);

        jPanel88.add(jPanel22, java.awt.BorderLayout.CENTER);

        jPanel7.add(jPanel88);

        jPanel5.add(jPanel7, java.awt.BorderLayout.CENTER);

        jPanel3.add(jPanel5, java.awt.BorderLayout.LINE_START);

        jTabbedPane2.setBackground(resourceMap.getColor("jTabbedPane2.background")); // NOI18N
        jTabbedPane2.setName("jTabbedPane2"); // NOI18N

        jPanel96.setName("jPanel96"); // NOI18N
        jPanel96.setLayout(new java.awt.BorderLayout());

        jPanel98.setName("jPanel98"); // NOI18N
        jPanel98.setPreferredSize(new java.awt.Dimension(130, 170));

        javax.swing.GroupLayout jPanel98Layout = new javax.swing.GroupLayout(jPanel98);
        jPanel98.setLayout(jPanel98Layout);
        jPanel98Layout.setHorizontalGroup(
            jPanel98Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 130, Short.MAX_VALUE)
        );
        jPanel98Layout.setVerticalGroup(
            jPanel98Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 221, Short.MAX_VALUE)
        );

        jPanel96.add(jPanel98, java.awt.BorderLayout.LINE_END);

        jPanel99.setName("jPanel99"); // NOI18N
        jPanel99.setPreferredSize(new java.awt.Dimension(100, 170));

        javax.swing.GroupLayout jPanel99Layout = new javax.swing.GroupLayout(jPanel99);
        jPanel99.setLayout(jPanel99Layout);
        jPanel99Layout.setHorizontalGroup(
            jPanel99Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel99Layout.setVerticalGroup(
            jPanel99Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 221, Short.MAX_VALUE)
        );

        jPanel96.add(jPanel99, java.awt.BorderLayout.LINE_START);

        jPanel100.setName("jPanel100"); // NOI18N
        jPanel100.setLayout(new java.awt.BorderLayout());

        jPanel101.setName("jPanel101"); // NOI18N
        jPanel101.setLayout(new java.awt.BorderLayout());

        jPanel102.setName("jPanel102"); // NOI18N
        jPanel102.setPreferredSize(new java.awt.Dimension(314, 20));

        javax.swing.GroupLayout jPanel102Layout = new javax.swing.GroupLayout(jPanel102);
        jPanel102.setLayout(jPanel102Layout);
        jPanel102Layout.setHorizontalGroup(
            jPanel102Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 355, Short.MAX_VALUE)
        );
        jPanel102Layout.setVerticalGroup(
            jPanel102Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 20, Short.MAX_VALUE)
        );

        jPanel101.add(jPanel102, java.awt.BorderLayout.PAGE_START);

        jPanel103.setName("jPanel103"); // NOI18N
        jPanel103.setLayout(new java.awt.BorderLayout());

        jPanel104.setName("jPanel104"); // NOI18N
        jPanel104.setLayout(new java.awt.GridLayout(2, 1, 3, 3));

        jPanel105.setName("jPanel105"); // NOI18N
        jPanel105.setLayout(new java.awt.GridLayout(3, 1, 3, 3));

        jPanel106.setName("jPanel106"); // NOI18N
        jPanel106.setLayout(new java.awt.BorderLayout());

        jLabel14.setText(resourceMap.getString("jLabel14.text")); // NOI18N
        jLabel14.setName("jLabel14"); // NOI18N
        jPanel106.add(jLabel14, java.awt.BorderLayout.CENTER);

        jPanel105.add(jPanel106);

        jPanel107.setName("jPanel107"); // NOI18N
        jPanel107.setLayout(new java.awt.BorderLayout());

        jLabel15.setText(resourceMap.getString("jLabel15.text")); // NOI18N
        jLabel15.setName("jLabel15"); // NOI18N
        jPanel107.add(jLabel15, java.awt.BorderLayout.CENTER);

        jPanel105.add(jPanel107);

        jPanel108.setName("jPanel108"); // NOI18N
        jPanel108.setLayout(new java.awt.BorderLayout());

        jLabel16.setText(resourceMap.getString("jLabel16.text")); // NOI18N
        jLabel16.setName("jLabel16"); // NOI18N
        jPanel108.add(jLabel16, java.awt.BorderLayout.CENTER);

        jPanel105.add(jPanel108);

        jPanel104.add(jPanel105);

        jPanel109.setName("jPanel109"); // NOI18N
        jPanel109.setLayout(new java.awt.BorderLayout());

        jPanel110.setName("jPanel110"); // NOI18N
        jPanel110.setPreferredSize(new java.awt.Dimension(100, 30));

        javax.swing.GroupLayout jPanel110Layout = new javax.swing.GroupLayout(jPanel110);
        jPanel110.setLayout(jPanel110Layout);
        jPanel110Layout.setHorizontalGroup(
            jPanel110Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel110Layout.setVerticalGroup(
            jPanel110Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 30, Short.MAX_VALUE)
        );

        jPanel109.add(jPanel110, java.awt.BorderLayout.PAGE_END);

        jPanel111.setName("jPanel111"); // NOI18N
        jPanel111.setPreferredSize(new java.awt.Dimension(100, 96));
        jPanel111.setLayout(new java.awt.BorderLayout());

        jLabel17.setText(resourceMap.getString("jLabel17.text")); // NOI18N
        jLabel17.setName("jLabel17"); // NOI18N
        jPanel111.add(jLabel17, java.awt.BorderLayout.PAGE_START);

        jPanel109.add(jPanel111, java.awt.BorderLayout.LINE_START);

        jPanel104.add(jPanel109);

        jPanel103.add(jPanel104, java.awt.BorderLayout.LINE_START);

        jPanel112.setName("jPanel112"); // NOI18N
        jPanel112.setLayout(new java.awt.GridLayout(2, 1, 3, 3));

        jPanel113.setName("jPanel113"); // NOI18N
        jPanel113.setLayout(new java.awt.GridLayout(3, 1, 3, 3));

        jPanel114.setName("jPanel114"); // NOI18N
        jPanel114.setLayout(new java.awt.BorderLayout());

        jTextFieldprice.setEditable(false);
        jTextFieldprice.setName("jTextFieldprice"); // NOI18N
        jTextFieldprice.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTextFieldpriceMouseClicked(evt);
            }
        });
        jPanel114.add(jTextFieldprice, java.awt.BorderLayout.CENTER);

        jPanel113.add(jPanel114);

        jPanel115.setName("jPanel115"); // NOI18N
        jPanel115.setLayout(new java.awt.BorderLayout());

        jTextFieldquantity.setName("jTextFieldquantity"); // NOI18N
        jTextFieldquantity.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTextFieldquantityMouseClicked(evt);
            }
        });
        jPanel115.add(jTextFieldquantity, java.awt.BorderLayout.CENTER);

        jPanel113.add(jPanel115);

        jPanel116.setName("jPanel116"); // NOI18N
        jPanel116.setLayout(new java.awt.BorderLayout());

        jPanel117.setName("jPanel117"); // NOI18N
        jPanel117.setPreferredSize(new java.awt.Dimension(30, 27));
        jPanel117.setLayout(new java.awt.BorderLayout());

        jLabel18.setText(resourceMap.getString("jLabel18.text")); // NOI18N
        jLabel18.setName("jLabel18"); // NOI18N
        jPanel117.add(jLabel18, java.awt.BorderLayout.LINE_START);

        jPanel116.add(jPanel117, java.awt.BorderLayout.LINE_END);

        jPanel118.setName("jPanel118"); // NOI18N
        jPanel118.setLayout(new java.awt.BorderLayout());

        jTextFielddiscountrate.setEditable(false);
        jTextFielddiscountrate.setName("jTextFielddiscountrate"); // NOI18N
        jTextFielddiscountrate.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTextFielddiscountrateMouseClicked(evt);
            }
        });
        jTextFielddiscountrate.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jTextFielddiscountrateActionPerformed(evt);
            }
        });
        jPanel118.add(jTextFielddiscountrate, java.awt.BorderLayout.CENTER);

        jPanel116.add(jPanel118, java.awt.BorderLayout.CENTER);

        jPanel113.add(jPanel116);

        jPanel112.add(jPanel113);

        jPanel119.setName("jPanel119"); // NOI18N
        jPanel119.setLayout(new java.awt.BorderLayout());

        jPanel120.setName("jPanel120"); // NOI18N
        jPanel120.setPreferredSize(new java.awt.Dimension(214, 30));
        jPanel120.setLayout(new java.awt.BorderLayout());

        jPanel123.setName("jPanel123"); // NOI18N
        jPanel123.setLayout(new java.awt.BorderLayout());

        jPanel124.setName("jPanel124"); // NOI18N
        jPanel124.setPreferredSize(new java.awt.Dimension(120, 30));
        jPanel124.setLayout(new java.awt.BorderLayout());

        jButton12.setIcon(resourceMap.getIcon("jButton12.icon")); // NOI18N
        jButton12.setText(resourceMap.getString("jButton12.text")); // NOI18N
        jButton12.setName("jButton12"); // NOI18N
        jButton12.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton12ActionPerformed(evt);
            }
        });
        jPanel124.add(jButton12, java.awt.BorderLayout.CENTER);

        jPanel123.add(jPanel124, java.awt.BorderLayout.LINE_START);

        jPanel125.setName("jPanel125"); // NOI18N
        jPanel125.setPreferredSize(new java.awt.Dimension(120, 30));
        jPanel125.setLayout(new java.awt.BorderLayout());

        jButton13.setIcon(resourceMap.getIcon("jButton13.icon")); // NOI18N
        jButton13.setText(resourceMap.getString("jButton13.text")); // NOI18N
        jButton13.setName("jButton13"); // NOI18N
        jButton13.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton13ActionPerformed(evt);
            }
        });
        jPanel125.add(jButton13, java.awt.BorderLayout.CENTER);

        jPanel123.add(jPanel125, java.awt.BorderLayout.LINE_END);

        jPanel126.setName("jPanel126"); // NOI18N
        jPanel126.setPreferredSize(new java.awt.Dimension(3, 30));

        javax.swing.GroupLayout jPanel126Layout = new javax.swing.GroupLayout(jPanel126);
        jPanel126.setLayout(jPanel126Layout);
        jPanel126Layout.setHorizontalGroup(
            jPanel126Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 15, Short.MAX_VALUE)
        );
        jPanel126Layout.setVerticalGroup(
            jPanel126Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 30, Short.MAX_VALUE)
        );

        jPanel123.add(jPanel126, java.awt.BorderLayout.CENTER);

        jPanel120.add(jPanel123, java.awt.BorderLayout.CENTER);

        jPanel119.add(jPanel120, java.awt.BorderLayout.PAGE_END);

        jPanel127.setName("jPanel127"); // NOI18N
        jPanel127.setLayout(new java.awt.BorderLayout());

        jScrollPane3.setName("jScrollPane3"); // NOI18N

        jTextAreadesription.setColumns(20);
        jTextAreadesription.setRows(5);
        jTextAreadesription.setName("jTextAreadesription"); // NOI18N
        jScrollPane3.setViewportView(jTextAreadesription);

        jPanel127.add(jScrollPane3, java.awt.BorderLayout.CENTER);

        jPanel119.add(jPanel127, java.awt.BorderLayout.CENTER);

        jPanel112.add(jPanel119);

        jPanel103.add(jPanel112, java.awt.BorderLayout.CENTER);

        jPanel101.add(jPanel103, java.awt.BorderLayout.CENTER);

        jPanel100.add(jPanel101, java.awt.BorderLayout.CENTER);

        jPanel96.add(jPanel100, java.awt.BorderLayout.CENTER);

        jTabbedPane2.addTab(resourceMap.getString("jPanel96.TabConstraints.tabTitle"), jPanel96); // NOI18N

        jPanel97.setName("jPanel97"); // NOI18N
        jPanel97.setLayout(new java.awt.BorderLayout());

        jPanel128.setName("jPanel128"); // NOI18N
        jPanel128.setPreferredSize(new java.awt.Dimension(390, 172));
        jPanel128.setLayout(new java.awt.BorderLayout());

        jLabel19.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel19.setText(resourceMap.getString("jLabel19.text")); // NOI18N
        jLabel19.setName("jLabel19"); // NOI18N
        jPanel128.add(jLabel19, java.awt.BorderLayout.PAGE_START);

        jPanel129.setName("jPanel129"); // NOI18N
        jPanel129.setPreferredSize(new java.awt.Dimension(458, 402));
        jPanel129.setLayout(new java.awt.BorderLayout());

        jScrollPane4.setName("jScrollPane4"); // NOI18N

        jTableeditsalesbill2.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        jTableeditsalesbill2.setName("jTableeditsalesbill2"); // NOI18N
        jTableeditsalesbill2.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTableeditsalesbill2MouseClicked(evt);
            }
        });
        jScrollPane4.setViewportView(jTableeditsalesbill2);
        jTableeditsalesbill2.getColumnModel().getColumn(0).setHeaderValue(resourceMap.getString("jTableeditsalesbill2.columnModel.title0")); // NOI18N
        jTableeditsalesbill2.getColumnModel().getColumn(1).setHeaderValue(resourceMap.getString("jTableeditsalesbill2.columnModel.title1")); // NOI18N
        jTableeditsalesbill2.getColumnModel().getColumn(2).setHeaderValue(resourceMap.getString("jTableeditsalesbill2.columnModel.title2")); // NOI18N
        jTableeditsalesbill2.getColumnModel().getColumn(3).setHeaderValue(resourceMap.getString("jTableeditsalesbill2.columnModel.title3")); // NOI18N

        jPanel129.add(jScrollPane4, java.awt.BorderLayout.CENTER);

        jPanel128.add(jPanel129, java.awt.BorderLayout.CENTER);

        jPanel97.add(jPanel128, java.awt.BorderLayout.LINE_START);

        jPanel130.setName("jPanel130"); // NOI18N
        jPanel130.setLayout(new java.awt.BorderLayout());

        jPanel131.setName("jPanel131"); // NOI18N
        jPanel131.setPreferredSize(new java.awt.Dimension(80, 181));
        jPanel131.setLayout(new java.awt.GridLayout(3, 1, 3, 3));

        jPanel136.setName("jPanel136"); // NOI18N
        jPanel136.setLayout(new java.awt.GridLayout(2, 1, 3, 3));

        jPanel139.setName("jPanel139"); // NOI18N
        jPanel139.setLayout(new java.awt.BorderLayout());

        jLabel21.setText(resourceMap.getString("jLabel21.text")); // NOI18N
        jLabel21.setName("jLabel21"); // NOI18N
        jPanel139.add(jLabel21, java.awt.BorderLayout.CENTER);

        jPanel136.add(jPanel139);

        jPanel140.setName("jPanel140"); // NOI18N
        jPanel140.setLayout(new java.awt.BorderLayout());

        jLabel22.setText(resourceMap.getString("jLabel22.text")); // NOI18N
        jLabel22.setName("jLabel22"); // NOI18N
        jPanel140.add(jLabel22, java.awt.BorderLayout.CENTER);

        jPanel136.add(jPanel140);

        jPanel131.add(jPanel136);

        jPanel137.setName("jPanel137"); // NOI18N
        jPanel137.setLayout(new java.awt.GridLayout(2, 1, 3, 3));

        jPanel141.setName("jPanel141"); // NOI18N
        jPanel141.setLayout(new java.awt.BorderLayout());

        jLabel23.setText(resourceMap.getString("jLabel23.text")); // NOI18N
        jLabel23.setName("jLabel23"); // NOI18N
        jPanel141.add(jLabel23, java.awt.BorderLayout.CENTER);

        jPanel137.add(jPanel141);

        jPanel142.setName("jPanel142"); // NOI18N
        jPanel142.setLayout(new java.awt.BorderLayout());

        jLabel20.setText(resourceMap.getString("jLabel20.text")); // NOI18N
        jLabel20.setName("jLabel20"); // NOI18N
        jPanel142.add(jLabel20, java.awt.BorderLayout.CENTER);

        jPanel137.add(jPanel142);

        jPanel131.add(jPanel137);

        jPanel138.setName("jPanel138"); // NOI18N
        jPanel138.setLayout(new java.awt.GridLayout(2, 1, 3, 3));

        jPanel147.setName("jPanel147"); // NOI18N
        jPanel147.setLayout(new java.awt.BorderLayout());

        jLabel9.setText(resourceMap.getString("jLabel9.text")); // NOI18N
        jLabel9.setName("jLabel9"); // NOI18N
        jPanel147.add(jLabel9, java.awt.BorderLayout.CENTER);

        jPanel138.add(jPanel147);

        jPanel131.add(jPanel138);

        jPanel130.add(jPanel131, java.awt.BorderLayout.LINE_START);

        jPanel132.setName("jPanel132"); // NOI18N
        jPanel132.setLayout(new java.awt.GridLayout(3, 1, 3, 3));

        jPanel133.setName("jPanel133"); // NOI18N
        jPanel133.setLayout(new java.awt.GridLayout(2, 1, 3, 3));

        jPanel143.setName("jPanel143"); // NOI18N
        jPanel143.setLayout(new java.awt.BorderLayout());

        jComboBoxproductname22.setName("jComboBoxproductname22"); // NOI18N
        jPanel143.add(jComboBoxproductname22, java.awt.BorderLayout.CENTER);

        jPanel133.add(jPanel143);

        jPanel144.setName("jPanel144"); // NOI18N
        jPanel144.setLayout(new java.awt.BorderLayout());

        jTextFieldprice2.setEditable(false);
        jTextFieldprice2.setText(resourceMap.getString("jTextFieldprice2.text")); // NOI18N
        jTextFieldprice2.setName("jTextFieldprice2"); // NOI18N
        jPanel144.add(jTextFieldprice2, java.awt.BorderLayout.CENTER);

        jPanel133.add(jPanel144);

        jPanel132.add(jPanel133);

        jPanel134.setName("jPanel134"); // NOI18N
        jPanel134.setLayout(new java.awt.GridLayout(2, 1, 3, 3));

        jPanel145.setName("jPanel145"); // NOI18N
        jPanel145.setLayout(new java.awt.BorderLayout());

        jTextFieldquantity2.setEditable(false);
        jTextFieldquantity2.setText(resourceMap.getString("jTextFieldquantity2.text")); // NOI18N
        jTextFieldquantity2.setName("jTextFieldquantity2"); // NOI18N
        jPanel145.add(jTextFieldquantity2, java.awt.BorderLayout.CENTER);

        jPanel134.add(jPanel145);

        jPanel146.setName("jPanel146"); // NOI18N
        jPanel146.setLayout(new java.awt.BorderLayout());

        jPanel148.setName("jPanel148"); // NOI18N
        jPanel148.setPreferredSize(new java.awt.Dimension(25, 27));
        jPanel148.setLayout(new java.awt.BorderLayout());

        jLabel24.setText(resourceMap.getString("jLabel24.text")); // NOI18N
        jLabel24.setName("jLabel24"); // NOI18N
        jPanel148.add(jLabel24, java.awt.BorderLayout.CENTER);

        jPanel146.add(jPanel148, java.awt.BorderLayout.LINE_END);

        jPanel149.setName("jPanel149"); // NOI18N
        jPanel149.setLayout(new java.awt.BorderLayout());

        jTextFielddcountrate2.setEditable(false);
        jTextFielddcountrate2.setText(resourceMap.getString("jTextFielddcountrate2.text")); // NOI18N
        jTextFielddcountrate2.setName("jTextFielddcountrate2"); // NOI18N
        jPanel149.add(jTextFielddcountrate2, java.awt.BorderLayout.CENTER);

        jPanel146.add(jPanel149, java.awt.BorderLayout.CENTER);

        jPanel134.add(jPanel146);

        jPanel132.add(jPanel134);

        jPanel135.setName("jPanel135"); // NOI18N
        jPanel135.setLayout(new java.awt.BorderLayout());

        jScrollPane5.setName("jScrollPane5"); // NOI18N

        jTextAreadescription.setColumns(20);
        jTextAreadescription.setEditable(false);
        jTextAreadescription.setRows(5);
        jTextAreadescription.setName("jTextAreadescription"); // NOI18N
        jScrollPane5.setViewportView(jTextAreadescription);

        jPanel135.add(jScrollPane5, java.awt.BorderLayout.CENTER);

        jPanel132.add(jPanel135);

        jPanel130.add(jPanel132, java.awt.BorderLayout.CENTER);

        jPanel97.add(jPanel130, java.awt.BorderLayout.CENTER);

        jTabbedPane2.addTab(resourceMap.getString("jPanel97.TabConstraints.tabTitle"), jPanel97); // NOI18N

        jPanel161.setName("jPanel161"); // NOI18N
        jPanel161.setLayout(new java.awt.BorderLayout());

        jPanel162.setName("jPanel162"); // NOI18N
        jPanel162.setLayout(new java.awt.GridLayout(6, 1, 3, 3));

        jPanel122.setName("jPanel122"); // NOI18N
        jPanel122.setPreferredSize(new java.awt.Dimension(80, 34));

        javax.swing.GroupLayout jPanel122Layout = new javax.swing.GroupLayout(jPanel122);
        jPanel122.setLayout(jPanel122Layout);
        jPanel122Layout.setHorizontalGroup(
            jPanel122Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 80, Short.MAX_VALUE)
        );
        jPanel122Layout.setVerticalGroup(
            jPanel122Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 34, Short.MAX_VALUE)
        );

        jPanel162.add(jPanel122);

        jPanel167.setName("jPanel167"); // NOI18N
        jPanel167.setLayout(new java.awt.BorderLayout());

        jLabel26.setText(resourceMap.getString("jLabel26.text")); // NOI18N
        jLabel26.setName("jLabel26"); // NOI18N
        jPanel167.add(jLabel26, java.awt.BorderLayout.CENTER);

        jPanel162.add(jPanel167);

        jPanel168.setName("jPanel168"); // NOI18N
        jPanel168.setLayout(new java.awt.BorderLayout());

        jLabel27.setText(resourceMap.getString("jLabel27.text")); // NOI18N
        jLabel27.setName("jLabel27"); // NOI18N
        jPanel168.add(jLabel27, java.awt.BorderLayout.CENTER);

        jPanel162.add(jPanel168);

        jPanel169.setName("jPanel169"); // NOI18N
        jPanel169.setLayout(new java.awt.BorderLayout());

        jLabel28.setText(resourceMap.getString("jLabel28.text")); // NOI18N
        jLabel28.setName("jLabel28"); // NOI18N
        jPanel169.add(jLabel28, java.awt.BorderLayout.CENTER);

        jPanel162.add(jPanel169);

        jPanel170.setName("jPanel170"); // NOI18N
        jPanel170.setLayout(new java.awt.BorderLayout());

        jLabel29.setText(resourceMap.getString("jLabel29.text")); // NOI18N
        jLabel29.setName("jLabel29"); // NOI18N
        jPanel170.add(jLabel29, java.awt.BorderLayout.CENTER);

        jPanel162.add(jPanel170);

        jPanel171.setName("jPanel171"); // NOI18N
        jPanel171.setLayout(new java.awt.BorderLayout());

        jLabel30.setText(resourceMap.getString("jLabel30.text")); // NOI18N
        jLabel30.setName("jLabel30"); // NOI18N
        jPanel171.add(jLabel30, java.awt.BorderLayout.CENTER);

        jPanel162.add(jPanel171);

        jPanel161.add(jPanel162, java.awt.BorderLayout.LINE_START);

        jPanel163.setName("jPanel163"); // NOI18N
        jPanel163.setPreferredSize(new java.awt.Dimension(30, 198));

        javax.swing.GroupLayout jPanel163Layout = new javax.swing.GroupLayout(jPanel163);
        jPanel163.setLayout(jPanel163Layout);
        jPanel163Layout.setHorizontalGroup(
            jPanel163Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 30, Short.MAX_VALUE)
        );
        jPanel163Layout.setVerticalGroup(
            jPanel163Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 221, Short.MAX_VALUE)
        );

        jPanel161.add(jPanel163, java.awt.BorderLayout.LINE_END);

        jPanel164.setName("jPanel164"); // NOI18N
        jPanel164.setLayout(new java.awt.BorderLayout());

        jPanel165.setName("jPanel165"); // NOI18N
        jPanel165.setPreferredSize(new java.awt.Dimension(250, 171));
        jPanel165.setLayout(new java.awt.GridLayout(6, 1, 3, 3));

        jPanel121.setName("jPanel121"); // NOI18N

        javax.swing.GroupLayout jPanel121Layout = new javax.swing.GroupLayout(jPanel121);
        jPanel121.setLayout(jPanel121Layout);
        jPanel121Layout.setHorizontalGroup(
            jPanel121Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 250, Short.MAX_VALUE)
        );
        jPanel121Layout.setVerticalGroup(
            jPanel121Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 34, Short.MAX_VALUE)
        );

        jPanel165.add(jPanel121);

        jPanel172.setName("jPanel172"); // NOI18N
        jPanel172.setLayout(new java.awt.BorderLayout());

        jTextFieldctmname.setText(resourceMap.getString("jTextFieldctmname.text")); // NOI18N
        jTextFieldctmname.setName("jTextFieldctmname"); // NOI18N
        jTextFieldctmname.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTextFieldctmnameMouseClicked(evt);
            }
        });
        jPanel172.add(jTextFieldctmname, java.awt.BorderLayout.CENTER);

        jPanel165.add(jPanel172);

        jPanel173.setName("jPanel173"); // NOI18N
        jPanel173.setLayout(new java.awt.BorderLayout());

        jTextFieldadress.setText(resourceMap.getString("jTextFieldadress.text")); // NOI18N
        jTextFieldadress.setName("jTextFieldadress"); // NOI18N
        jTextFieldadress.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTextFieldadressMouseClicked(evt);
            }
        });
        jPanel173.add(jTextFieldadress, java.awt.BorderLayout.CENTER);

        jPanel165.add(jPanel173);

        jPanel174.setName("jPanel174"); // NOI18N
        jPanel174.setLayout(new java.awt.BorderLayout());

        jTextFieldphone.setText(resourceMap.getString("jTextFieldphone.text")); // NOI18N
        jTextFieldphone.setName("jTextFieldphone"); // NOI18N
        jTextFieldphone.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTextFieldphoneMouseClicked(evt);
            }
        });
        jPanel174.add(jTextFieldphone, java.awt.BorderLayout.CENTER);

        jPanel165.add(jPanel174);

        jPanel175.setName("jPanel175"); // NOI18N
        jPanel175.setLayout(new java.awt.BorderLayout());

        jTextFieldemail.setText(resourceMap.getString("jTextFieldemail.text")); // NOI18N
        jTextFieldemail.setName("jTextFieldemail"); // NOI18N
        jTextFieldemail.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTextFieldemailMouseClicked(evt);
            }
        });
        jPanel175.add(jTextFieldemail, java.awt.BorderLayout.CENTER);

        jPanel165.add(jPanel175);

        jPanel176.setName("jPanel176"); // NOI18N
        jPanel176.setLayout(new java.awt.BorderLayout());

        jPanel177.setName("jPanel177"); // NOI18N
        jPanel177.setPreferredSize(new java.awt.Dimension(170, 31));
        jPanel177.setLayout(new java.awt.BorderLayout());

        jPanel179.setName("jPanel179"); // NOI18N
        jPanel179.setPreferredSize(new java.awt.Dimension(80, 31));
        jPanel179.setLayout(new java.awt.BorderLayout());

        jLabel31.setText(resourceMap.getString("jLabel31.text")); // NOI18N
        jLabel31.setName("jLabel31"); // NOI18N
        jPanel179.add(jLabel31, java.awt.BorderLayout.CENTER);

        jPanel177.add(jPanel179, java.awt.BorderLayout.LINE_START);

        jPanel180.setName("jPanel180"); // NOI18N
        jPanel180.setLayout(new java.awt.BorderLayout());

        jComboBoxcustmtype.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Select", "retail", "wholesale" }));
        jComboBoxcustmtype.setName("jComboBoxcustmtype"); // NOI18N
        jComboBoxcustmtype.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jComboBoxcustmtypeActionPerformed(evt);
            }
        });
        jPanel180.add(jComboBoxcustmtype, java.awt.BorderLayout.CENTER);

        jPanel177.add(jPanel180, java.awt.BorderLayout.CENTER);

        jPanel176.add(jPanel177, java.awt.BorderLayout.LINE_END);

        jPanel178.setName("jPanel178"); // NOI18N
        jPanel178.setLayout(new java.awt.BorderLayout());

        jComboBoxgender.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Select", "male", "woman" }));
        jComboBoxgender.setName("jComboBoxgender"); // NOI18N
        jComboBoxgender.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jComboBoxgenderActionPerformed(evt);
            }
        });
        jPanel178.add(jComboBoxgender, java.awt.BorderLayout.CENTER);

        jPanel176.add(jPanel178, java.awt.BorderLayout.CENTER);

        jPanel165.add(jPanel176);

        jPanel164.add(jPanel165, java.awt.BorderLayout.LINE_START);

        jPanel166.setName("jPanel166"); // NOI18N
        jPanel166.setLayout(new java.awt.BorderLayout());

        jPanel181.setName("jPanel181"); // NOI18N
        jPanel181.setPreferredSize(new java.awt.Dimension(30, 198));

        javax.swing.GroupLayout jPanel181Layout = new javax.swing.GroupLayout(jPanel181);
        jPanel181.setLayout(jPanel181Layout);
        jPanel181Layout.setHorizontalGroup(
            jPanel181Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 30, Short.MAX_VALUE)
        );
        jPanel181Layout.setVerticalGroup(
            jPanel181Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 221, Short.MAX_VALUE)
        );

        jPanel166.add(jPanel181, java.awt.BorderLayout.LINE_START);

        jPanel182.setName("jPanel182"); // NOI18N
        jPanel182.setLayout(new java.awt.BorderLayout());

        jPanel183.setName("jPanel183"); // NOI18N
        jPanel183.setPreferredSize(new java.awt.Dimension(195, 30));
        jPanel183.setLayout(new java.awt.BorderLayout());

        jLabel32.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel32.setText(resourceMap.getString("jLabel32.text")); // NOI18N
        jLabel32.setName("jLabel32"); // NOI18N
        jPanel183.add(jLabel32, java.awt.BorderLayout.CENTER);

        jPanel182.add(jPanel183, java.awt.BorderLayout.PAGE_START);

        jPanel184.setName("jPanel184"); // NOI18N
        jPanel184.setPreferredSize(new java.awt.Dimension(195, 35));
        jPanel184.setLayout(new java.awt.BorderLayout());

        jPanel186.setName("jPanel186"); // NOI18N
        jPanel186.setPreferredSize(new java.awt.Dimension(90, 35));
        jPanel186.setLayout(new java.awt.BorderLayout());

        jButton17.setIcon(resourceMap.getIcon("jButton17.icon")); // NOI18N
        jButton17.setText(resourceMap.getString("jButton17.text")); // NOI18N
        jButton17.setName("jButton17"); // NOI18N
        jButton17.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton17ActionPerformed(evt);
            }
        });
        jPanel186.add(jButton17, java.awt.BorderLayout.CENTER);

        jPanel184.add(jPanel186, java.awt.BorderLayout.LINE_START);

        jPanel187.setName("jPanel187"); // NOI18N
        jPanel187.setPreferredSize(new java.awt.Dimension(95, 35));
        jPanel187.setLayout(new java.awt.BorderLayout());

        jButton18.setIcon(resourceMap.getIcon("jButton18.icon")); // NOI18N
        jButton18.setText(resourceMap.getString("jButton18.text")); // NOI18N
        jButton18.setName("jButton18"); // NOI18N
        jButton18.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton18ActionPerformed(evt);
            }
        });
        jPanel187.add(jButton18, java.awt.BorderLayout.CENTER);

        jPanel184.add(jPanel187, java.awt.BorderLayout.LINE_END);

        jPanel182.add(jPanel184, java.awt.BorderLayout.PAGE_END);

        jPanel185.setName("jPanel185"); // NOI18N
        jPanel185.setLayout(new java.awt.BorderLayout());

        jScrollPane6.setName("jScrollPane6"); // NOI18N

        jTextAreadription.setColumns(20);
        jTextAreadription.setRows(5);
        jTextAreadription.setName("jTextAreadription"); // NOI18N
        jScrollPane6.setViewportView(jTextAreadription);

        jPanel185.add(jScrollPane6, java.awt.BorderLayout.CENTER);

        jPanel182.add(jPanel185, java.awt.BorderLayout.CENTER);

        jPanel166.add(jPanel182, java.awt.BorderLayout.CENTER);

        jPanel164.add(jPanel166, java.awt.BorderLayout.CENTER);

        jPanel161.add(jPanel164, java.awt.BorderLayout.CENTER);

        jTabbedPane2.addTab(resourceMap.getString("jPanel161.TabConstraints.tabTitle"), jPanel161); // NOI18N

        jPanel3.add(jTabbedPane2, java.awt.BorderLayout.CENTER);

        jPanel1.add(jPanel3);

        jPanel4.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(resourceMap.getColor("jPanel4.border.border.lineColor"), 2), resourceMap.getString("jPanel4.border.title"))); // NOI18N
        jPanel4.setName("jPanel4"); // NOI18N
        jPanel4.setLayout(new java.awt.BorderLayout());

        jPanel64.setName("jPanel64"); // NOI18N
        jPanel64.setPreferredSize(new java.awt.Dimension(942, 30));
        jPanel64.setLayout(new java.awt.BorderLayout());

        jPanel66.setName("jPanel66"); // NOI18N
        jPanel66.setPreferredSize(new java.awt.Dimension(250, 30));

        javax.swing.GroupLayout jPanel66Layout = new javax.swing.GroupLayout(jPanel66);
        jPanel66.setLayout(jPanel66Layout);
        jPanel66Layout.setHorizontalGroup(
            jPanel66Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 250, Short.MAX_VALUE)
        );
        jPanel66Layout.setVerticalGroup(
            jPanel66Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 30, Short.MAX_VALUE)
        );

        jPanel64.add(jPanel66, java.awt.BorderLayout.LINE_START);

        jPanel67.setName("jPanel67"); // NOI18N
        jPanel67.setPreferredSize(new java.awt.Dimension(252, 30));
        jPanel67.setLayout(new java.awt.BorderLayout());

        jPanel74.setName("jPanel74"); // NOI18N
        jPanel74.setPreferredSize(new java.awt.Dimension(50, 30));
        jPanel74.setLayout(new java.awt.BorderLayout());

        jLabel10.setText(resourceMap.getString("jLabel10.text")); // NOI18N
        jLabel10.setName("jLabel10"); // NOI18N
        jPanel74.add(jLabel10, java.awt.BorderLayout.CENTER);

        jPanel67.add(jPanel74, java.awt.BorderLayout.LINE_END);

        jPanel64.add(jPanel67, java.awt.BorderLayout.LINE_END);

        jPanel68.setName("jPanel68"); // NOI18N
        jPanel68.setLayout(new java.awt.BorderLayout());

        jPanel69.setName("jPanel69"); // NOI18N
        jPanel69.setPreferredSize(new java.awt.Dimension(110, 30));
        jPanel69.setLayout(new java.awt.BorderLayout());

        jButton6.setIcon(resourceMap.getIcon("jButton6.icon")); // NOI18N
        jButton6.setText(resourceMap.getString("jButton6.text")); // NOI18N
        jButton6.setHorizontalTextPosition(javax.swing.SwingConstants.LEFT);
        jButton6.setName("jButton6"); // NOI18N
        jButton6.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton6ActionPerformed(evt);
            }
        });
        jPanel69.add(jButton6, java.awt.BorderLayout.CENTER);

        jPanel68.add(jPanel69, java.awt.BorderLayout.LINE_START);

        jPanel70.setName("jPanel70"); // NOI18N
        jPanel70.setPreferredSize(new java.awt.Dimension(110, 30));
        jPanel70.setLayout(new java.awt.BorderLayout());

        jButton8.setIcon(resourceMap.getIcon("jButton8.icon")); // NOI18N
        jButton8.setText(resourceMap.getString("jButton8.text")); // NOI18N
        jButton8.setName("jButton8"); // NOI18N
        jPanel70.add(jButton8, java.awt.BorderLayout.CENTER);

        jPanel68.add(jPanel70, java.awt.BorderLayout.LINE_END);

        jPanel71.setName("jPanel71"); // NOI18N
        jPanel71.setLayout(new java.awt.BorderLayout());

        jPanel72.setName("jPanel72"); // NOI18N
        jPanel72.setPreferredSize(new java.awt.Dimension(110, 30));
        jPanel72.setLayout(new java.awt.BorderLayout());

        jButton7.setIcon(resourceMap.getIcon("jButton7.icon")); // NOI18N
        jButton7.setText(resourceMap.getString("jButton7.text")); // NOI18N
        jButton7.setName("jButton7"); // NOI18N
        jButton7.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton7ActionPerformed(evt);
            }
        });
        jPanel72.add(jButton7, java.awt.BorderLayout.CENTER);

        jPanel71.add(jPanel72, java.awt.BorderLayout.LINE_START);

        jPanel73.setName("jPanel73"); // NOI18N
        jPanel73.setLayout(new java.awt.BorderLayout());

        jTextField6.setText(resourceMap.getString("jTextField6.text")); // NOI18N
        jTextField6.setName("jTextField6"); // NOI18N
        jPanel73.add(jTextField6, java.awt.BorderLayout.CENTER);

        jPanel71.add(jPanel73, java.awt.BorderLayout.CENTER);

        jPanel68.add(jPanel71, java.awt.BorderLayout.CENTER);

        jPanel64.add(jPanel68, java.awt.BorderLayout.CENTER);

        jPanel4.add(jPanel64, java.awt.BorderLayout.PAGE_END);

        jPanel65.setName("jPanel65"); // NOI18N
        jPanel65.setLayout(new java.awt.BorderLayout());

        jScrollPane1.setName("jScrollPane1"); // NOI18N

        jTablecontent.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        jTablecontent.setName("jTablecontent"); // NOI18N
        jTablecontent.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTablecontentMouseClicked(evt);
            }
        });
        jScrollPane1.setViewportView(jTablecontent);

        jPanel65.add(jScrollPane1, java.awt.BorderLayout.PAGE_START);

        jButton15.setText(resourceMap.getString("jButton15.text")); // NOI18N
        jButton15.setName("jButton15"); // NOI18N
        jButton15.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton15ActionPerformed(evt);
            }
        });
        jPanel65.add(jButton15, java.awt.BorderLayout.CENTER);

        jPanel4.add(jPanel65, java.awt.BorderLayout.CENTER);

        jPanel1.add(jPanel4);

        jTabbedPane1.addTab(resourceMap.getString("jPanel1.TabConstraints.tabTitle"), jPanel1); // NOI18N

        jPanel2.setName("jPanel2"); // NOI18N
        jPanel2.setLayout(new java.awt.GridLayout(2, 1, 3, 3));

        jPanel33.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(resourceMap.getColor("jPanel33.border.border.lineColor"), 3))); // NOI18N
        jPanel33.setName("jPanel33"); // NOI18N
        jPanel33.setLayout(new java.awt.BorderLayout());

        jPanel35.setName("jPanel35"); // NOI18N
        jPanel35.setPreferredSize(new java.awt.Dimension(250, 202));

        javax.swing.GroupLayout jPanel35Layout = new javax.swing.GroupLayout(jPanel35);
        jPanel35.setLayout(jPanel35Layout);
        jPanel35Layout.setHorizontalGroup(
            jPanel35Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 250, Short.MAX_VALUE)
        );
        jPanel35Layout.setVerticalGroup(
            jPanel35Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 263, Short.MAX_VALUE)
        );

        jPanel33.add(jPanel35, java.awt.BorderLayout.LINE_START);

        jPanel36.setName("jPanel36"); // NOI18N
        jPanel36.setPreferredSize(new java.awt.Dimension(200, 202));

        javax.swing.GroupLayout jPanel36Layout = new javax.swing.GroupLayout(jPanel36);
        jPanel36.setLayout(jPanel36Layout);
        jPanel36Layout.setHorizontalGroup(
            jPanel36Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 200, Short.MAX_VALUE)
        );
        jPanel36Layout.setVerticalGroup(
            jPanel36Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 263, Short.MAX_VALUE)
        );

        jPanel33.add(jPanel36, java.awt.BorderLayout.LINE_END);

        jPanel37.setName("jPanel37"); // NOI18N
        jPanel37.setLayout(new java.awt.BorderLayout());

        jPanel28.setName("jPanel28"); // NOI18N
        jPanel28.setLayout(new java.awt.GridLayout(8, 1, 4, 4));

        jPanel31.setName("jPanel31"); // NOI18N

        javax.swing.GroupLayout jPanel31Layout = new javax.swing.GroupLayout(jPanel31);
        jPanel31.setLayout(jPanel31Layout);
        jPanel31Layout.setHorizontalGroup(
            jPanel31Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel31Layout.setVerticalGroup(
            jPanel31Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel28.add(jPanel31);

        jPanel32.setName("jPanel32"); // NOI18N

        javax.swing.GroupLayout jPanel32Layout = new javax.swing.GroupLayout(jPanel32);
        jPanel32.setLayout(jPanel32Layout);
        jPanel32Layout.setHorizontalGroup(
            jPanel32Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel32Layout.setVerticalGroup(
            jPanel32Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel28.add(jPanel32);

        jPanel38.setName("jPanel38"); // NOI18N
        jPanel38.setLayout(new java.awt.BorderLayout());

        jLabel7.setText(resourceMap.getString("jLabel7.text")); // NOI18N
        jLabel7.setName("jLabel7"); // NOI18N
        jPanel38.add(jLabel7, java.awt.BorderLayout.CENTER);

        jPanel28.add(jPanel38);

        jPanel39.setName("jPanel39"); // NOI18N
        jPanel39.setLayout(new java.awt.BorderLayout());

        jLabel8.setText(resourceMap.getString("jLabel8.text")); // NOI18N
        jLabel8.setName("jLabel8"); // NOI18N
        jPanel39.add(jLabel8, java.awt.BorderLayout.CENTER);

        jPanel28.add(jPanel39);

        jPanel40.setName("jPanel40"); // NOI18N
        jPanel40.setLayout(new java.awt.BorderLayout());
        jPanel28.add(jPanel40);

        jPanel41.setName("jPanel41"); // NOI18N

        javax.swing.GroupLayout jPanel41Layout = new javax.swing.GroupLayout(jPanel41);
        jPanel41.setLayout(jPanel41Layout);
        jPanel41Layout.setHorizontalGroup(
            jPanel41Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel41Layout.setVerticalGroup(
            jPanel41Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel28.add(jPanel41);

        jPanel42.setName("jPanel42"); // NOI18N

        javax.swing.GroupLayout jPanel42Layout = new javax.swing.GroupLayout(jPanel42);
        jPanel42.setLayout(jPanel42Layout);
        jPanel42Layout.setHorizontalGroup(
            jPanel42Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel42Layout.setVerticalGroup(
            jPanel42Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel28.add(jPanel42);

        jPanel43.setName("jPanel43"); // NOI18N

        javax.swing.GroupLayout jPanel43Layout = new javax.swing.GroupLayout(jPanel43);
        jPanel43.setLayout(jPanel43Layout);
        jPanel43Layout.setHorizontalGroup(
            jPanel43Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 100, Short.MAX_VALUE)
        );
        jPanel43Layout.setVerticalGroup(
            jPanel43Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel28.add(jPanel43);

        jPanel37.add(jPanel28, java.awt.BorderLayout.LINE_START);

        jPanel29.setName("jPanel29"); // NOI18N
        jPanel29.setLayout(new java.awt.GridLayout(8, 1, 4, 4));

        jPanel52.setName("jPanel52"); // NOI18N

        javax.swing.GroupLayout jPanel52Layout = new javax.swing.GroupLayout(jPanel52);
        jPanel52.setLayout(jPanel52Layout);
        jPanel52Layout.setHorizontalGroup(
            jPanel52Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 137, Short.MAX_VALUE)
        );
        jPanel52Layout.setVerticalGroup(
            jPanel52Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel29.add(jPanel52);

        jPanel53.setName("jPanel53"); // NOI18N

        javax.swing.GroupLayout jPanel53Layout = new javax.swing.GroupLayout(jPanel53);
        jPanel53.setLayout(jPanel53Layout);
        jPanel53Layout.setHorizontalGroup(
            jPanel53Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 137, Short.MAX_VALUE)
        );
        jPanel53Layout.setVerticalGroup(
            jPanel53Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel29.add(jPanel53);

        jPanel54.setName("jPanel54"); // NOI18N
        jPanel54.setLayout(new java.awt.BorderLayout());

        jCheckBoxsearchbillname.setText(resourceMap.getString("jCheckBoxsearchbillname.text")); // NOI18N
        jCheckBoxsearchbillname.setName("jCheckBoxsearchbillname"); // NOI18N
        jCheckBoxsearchbillname.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jCheckBoxsearchbillnameMouseClicked(evt);
            }
        });
        jPanel54.add(jCheckBoxsearchbillname, java.awt.BorderLayout.CENTER);

        jPanel29.add(jPanel54);

        jPanel55.setName("jPanel55"); // NOI18N
        jPanel55.setLayout(new java.awt.BorderLayout());

        jCheckBoxsearchctomername.setText(resourceMap.getString("jCheckBoxsearchctomername.text")); // NOI18N
        jCheckBoxsearchctomername.setName("jCheckBoxsearchctomername"); // NOI18N
        jCheckBoxsearchctomername.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jCheckBoxsearchctomernameMouseClicked(evt);
            }
        });
        jPanel55.add(jCheckBoxsearchctomername, java.awt.BorderLayout.CENTER);

        jPanel29.add(jPanel55);

        jPanel56.setName("jPanel56"); // NOI18N
        jPanel56.setLayout(new java.awt.BorderLayout());
        jPanel29.add(jPanel56);

        jPanel57.setName("jPanel57"); // NOI18N

        javax.swing.GroupLayout jPanel57Layout = new javax.swing.GroupLayout(jPanel57);
        jPanel57.setLayout(jPanel57Layout);
        jPanel57Layout.setHorizontalGroup(
            jPanel57Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 137, Short.MAX_VALUE)
        );
        jPanel57Layout.setVerticalGroup(
            jPanel57Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel29.add(jPanel57);

        jPanel58.setName("jPanel58"); // NOI18N

        javax.swing.GroupLayout jPanel58Layout = new javax.swing.GroupLayout(jPanel58);
        jPanel58.setLayout(jPanel58Layout);
        jPanel58Layout.setHorizontalGroup(
            jPanel58Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 137, Short.MAX_VALUE)
        );
        jPanel58Layout.setVerticalGroup(
            jPanel58Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel29.add(jPanel58);

        jPanel59.setName("jPanel59"); // NOI18N

        javax.swing.GroupLayout jPanel59Layout = new javax.swing.GroupLayout(jPanel59);
        jPanel59.setLayout(jPanel59Layout);
        jPanel59Layout.setHorizontalGroup(
            jPanel59Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 137, Short.MAX_VALUE)
        );
        jPanel59Layout.setVerticalGroup(
            jPanel59Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel29.add(jPanel59);

        jPanel37.add(jPanel29, java.awt.BorderLayout.LINE_END);

        jPanel30.setName("jPanel30"); // NOI18N
        jPanel30.setLayout(new java.awt.GridLayout(8, 1, 4, 4));

        jPanel44.setName("jPanel44"); // NOI18N
        jPanel44.setLayout(new java.awt.BorderLayout());

        jLabel6.setFont(resourceMap.getFont("jLabel6.font")); // NOI18N
        jLabel6.setForeground(resourceMap.getColor("jLabel6.foreground")); // NOI18N
        jLabel6.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel6.setText(resourceMap.getString("jLabel6.text")); // NOI18N
        jLabel6.setName("jLabel6"); // NOI18N
        jPanel44.add(jLabel6, java.awt.BorderLayout.CENTER);

        jPanel30.add(jPanel44);

        jPanel45.setName("jPanel45"); // NOI18N

        javax.swing.GroupLayout jPanel45Layout = new javax.swing.GroupLayout(jPanel45);
        jPanel45.setLayout(jPanel45Layout);
        jPanel45Layout.setHorizontalGroup(
            jPanel45Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 253, Short.MAX_VALUE)
        );
        jPanel45Layout.setVerticalGroup(
            jPanel45Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel30.add(jPanel45);

        jPanel46.setName("jPanel46"); // NOI18N
        jPanel46.setLayout(new java.awt.BorderLayout());

        jTextFieldsearchbillname.setText(resourceMap.getString("jTextFieldsearchbillname.text")); // NOI18N
        jTextFieldsearchbillname.setName("jTextFieldsearchbillname"); // NOI18N
        jTextFieldsearchbillname.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTextFieldsearchbillnameMouseClicked(evt);
            }
        });
        jPanel46.add(jTextFieldsearchbillname, java.awt.BorderLayout.CENTER);

        jPanel30.add(jPanel46);

        jPanel47.setName("jPanel47"); // NOI18N
        jPanel47.setLayout(new java.awt.BorderLayout());

        jComboBoxctmsearch.setName("jComboBoxctmsearch"); // NOI18N
        jComboBoxctmsearch.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jComboBoxctmsearchActionPerformed(evt);
            }
        });
        jPanel47.add(jComboBoxctmsearch, java.awt.BorderLayout.CENTER);

        jPanel30.add(jPanel47);

        jPanel48.setName("jPanel48"); // NOI18N
        jPanel48.setLayout(new java.awt.BorderLayout());

        jLabelero.setFont(resourceMap.getFont("jLabelero.font")); // NOI18N
        jLabelero.setForeground(resourceMap.getColor("jLabelero.foreground")); // NOI18N
        jLabelero.setText(resourceMap.getString("jLabelero.text")); // NOI18N
        jLabelero.setName("jLabelero"); // NOI18N
        jLabelero.setOpaque(true);
        jPanel48.add(jLabelero, java.awt.BorderLayout.CENTER);

        jPanel30.add(jPanel48);

        jPanel49.setName("jPanel49"); // NOI18N
        jPanel49.setLayout(new java.awt.BorderLayout());

        jPanel60.setName("jPanel60"); // NOI18N
        jPanel60.setPreferredSize(new java.awt.Dimension(70, 23));

        javax.swing.GroupLayout jPanel60Layout = new javax.swing.GroupLayout(jPanel60);
        jPanel60.setLayout(jPanel60Layout);
        jPanel60Layout.setHorizontalGroup(
            jPanel60Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 70, Short.MAX_VALUE)
        );
        jPanel60Layout.setVerticalGroup(
            jPanel60Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel49.add(jPanel60, java.awt.BorderLayout.LINE_START);

        jPanel61.setName("jPanel61"); // NOI18N
        jPanel61.setLayout(new java.awt.BorderLayout());

        jPanel62.setName("jPanel62"); // NOI18N
        jPanel62.setPreferredSize(new java.awt.Dimension(100, 23));
        jPanel62.setLayout(new java.awt.BorderLayout());

        jButton5.setIcon(resourceMap.getIcon("jButton5.icon")); // NOI18N
        jButton5.setText(resourceMap.getString("jButton5.text")); // NOI18N
        jButton5.setName("jButton5"); // NOI18N
        jButton5.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton5ActionPerformed(evt);
            }
        });
        jPanel62.add(jButton5, java.awt.BorderLayout.CENTER);

        jPanel61.add(jPanel62, java.awt.BorderLayout.LINE_START);

        jPanel63.setName("jPanel63"); // NOI18N
        jPanel63.setPreferredSize(new java.awt.Dimension(80, 23));

        javax.swing.GroupLayout jPanel63Layout = new javax.swing.GroupLayout(jPanel63);
        jPanel63.setLayout(jPanel63Layout);
        jPanel63Layout.setHorizontalGroup(
            jPanel63Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 80, Short.MAX_VALUE)
        );
        jPanel63Layout.setVerticalGroup(
            jPanel63Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel61.add(jPanel63, java.awt.BorderLayout.LINE_END);

        jPanel49.add(jPanel61, java.awt.BorderLayout.CENTER);

        jPanel30.add(jPanel49);

        jPanel50.setName("jPanel50"); // NOI18N

        javax.swing.GroupLayout jPanel50Layout = new javax.swing.GroupLayout(jPanel50);
        jPanel50.setLayout(jPanel50Layout);
        jPanel50Layout.setHorizontalGroup(
            jPanel50Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 253, Short.MAX_VALUE)
        );
        jPanel50Layout.setVerticalGroup(
            jPanel50Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel30.add(jPanel50);

        jPanel51.setName("jPanel51"); // NOI18N

        javax.swing.GroupLayout jPanel51Layout = new javax.swing.GroupLayout(jPanel51);
        jPanel51.setLayout(jPanel51Layout);
        jPanel51Layout.setHorizontalGroup(
            jPanel51Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 253, Short.MAX_VALUE)
        );
        jPanel51Layout.setVerticalGroup(
            jPanel51Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 29, Short.MAX_VALUE)
        );

        jPanel30.add(jPanel51);

        jPanel37.add(jPanel30, java.awt.BorderLayout.CENTER);

        jPanel33.add(jPanel37, java.awt.BorderLayout.CENTER);

        jPanel2.add(jPanel33);

        jPanel34.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(resourceMap.getColor("jPanel34.border.border.lineColor"), 3), resourceMap.getString("jPanel34.border.title"))); // NOI18N
        jPanel34.setName("jPanel34"); // NOI18N
        jPanel34.setLayout(new java.awt.BorderLayout());

        jPanel77.setName("jPanel77"); // NOI18N
        jPanel77.setPreferredSize(new java.awt.Dimension(940, 30));
        jPanel77.setLayout(new java.awt.BorderLayout());

        jPanel79.setName("jPanel79"); // NOI18N
        jPanel79.setPreferredSize(new java.awt.Dimension(250, 30));

        javax.swing.GroupLayout jPanel79Layout = new javax.swing.GroupLayout(jPanel79);
        jPanel79.setLayout(jPanel79Layout);
        jPanel79Layout.setHorizontalGroup(
            jPanel79Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 250, Short.MAX_VALUE)
        );
        jPanel79Layout.setVerticalGroup(
            jPanel79Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 30, Short.MAX_VALUE)
        );

        jPanel77.add(jPanel79, java.awt.BorderLayout.LINE_START);

        jPanel80.setName("jPanel80"); // NOI18N
        jPanel80.setPreferredSize(new java.awt.Dimension(250, 30));
        jPanel80.setLayout(new java.awt.BorderLayout());

        jPanel87.setName("jPanel87"); // NOI18N
        jPanel87.setPreferredSize(new java.awt.Dimension(50, 30));
        jPanel87.setLayout(new java.awt.BorderLayout());

        jLabel11.setText(resourceMap.getString("jLabel11.text")); // NOI18N
        jLabel11.setName("jLabel11"); // NOI18N
        jPanel87.add(jLabel11, java.awt.BorderLayout.CENTER);

        jPanel80.add(jPanel87, java.awt.BorderLayout.LINE_END);

        jPanel77.add(jPanel80, java.awt.BorderLayout.LINE_END);

        jPanel81.setName("jPanel81"); // NOI18N
        jPanel81.setLayout(new java.awt.BorderLayout());

        jPanel82.setName("jPanel82"); // NOI18N
        jPanel82.setPreferredSize(new java.awt.Dimension(110, 30));
        jPanel82.setLayout(new java.awt.BorderLayout());

        jButton9.setIcon(resourceMap.getIcon("jButton9.icon")); // NOI18N
        jButton9.setText(resourceMap.getString("jButton9.text")); // NOI18N
        jButton9.setHorizontalTextPosition(javax.swing.SwingConstants.LEFT);
        jButton9.setName("jButton9"); // NOI18N
        jPanel82.add(jButton9, java.awt.BorderLayout.CENTER);

        jPanel81.add(jPanel82, java.awt.BorderLayout.LINE_START);

        jPanel83.setName("jPanel83"); // NOI18N
        jPanel83.setPreferredSize(new java.awt.Dimension(110, 30));
        jPanel83.setLayout(new java.awt.BorderLayout());

        jButton11.setIcon(resourceMap.getIcon("jButton11.icon")); // NOI18N
        jButton11.setText(resourceMap.getString("jButton11.text")); // NOI18N
        jButton11.setName("jButton11"); // NOI18N
        jPanel83.add(jButton11, java.awt.BorderLayout.CENTER);

        jPanel81.add(jPanel83, java.awt.BorderLayout.LINE_END);

        jPanel84.setName("jPanel84"); // NOI18N
        jPanel84.setLayout(new java.awt.BorderLayout());

        jPanel85.setName("jPanel85"); // NOI18N
        jPanel85.setPreferredSize(new java.awt.Dimension(110, 30));
        jPanel85.setLayout(new java.awt.BorderLayout());

        jButton10.setIcon(resourceMap.getIcon("jButton10.icon")); // NOI18N
        jButton10.setText(resourceMap.getString("jButton10.text")); // NOI18N
        jButton10.setName("jButton10"); // NOI18N
        jPanel85.add(jButton10, java.awt.BorderLayout.CENTER);

        jPanel84.add(jPanel85, java.awt.BorderLayout.LINE_START);

        jPanel86.setName("jPanel86"); // NOI18N
        jPanel86.setLayout(new java.awt.BorderLayout());

        jTextField7.setText(resourceMap.getString("jTextField7.text")); // NOI18N
        jTextField7.setName("jTextField7"); // NOI18N
        jPanel86.add(jTextField7, java.awt.BorderLayout.CENTER);

        jPanel84.add(jPanel86, java.awt.BorderLayout.CENTER);

        jPanel81.add(jPanel84, java.awt.BorderLayout.CENTER);

        jPanel77.add(jPanel81, java.awt.BorderLayout.CENTER);

        jPanel34.add(jPanel77, java.awt.BorderLayout.PAGE_END);

        jPanel78.setName("jPanel78"); // NOI18N
        jPanel78.setLayout(new java.awt.BorderLayout());

        jScrollPane2.setName("jScrollPane2"); // NOI18N

        jTablesearchsalesbill.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        jTablesearchsalesbill.setName("jTablesearchsalesbill"); // NOI18N
        jScrollPane2.setViewportView(jTablesearchsalesbill);

        jPanel78.add(jScrollPane2, java.awt.BorderLayout.CENTER);

        jPanel34.add(jPanel78, java.awt.BorderLayout.CENTER);

        jPanel2.add(jPanel34);

        jTabbedPane1.addTab(resourceMap.getString("jPanel2.TabConstraints.tabTitle"), jPanel2); // NOI18N

        getContentPane().add(jTabbedPane1, java.awt.BorderLayout.CENTER);

        pack();
    }// </editor-fold>//GEN-END:initComponents
       public void Createdetailsalesbill()
    {
        try
        {
           Vector<String> cols =new Vector<String>();
          // cols.add("Billid");
           //cols.add("ProductId");
           cols.add("ProductName");
           cols.add("Price");
           cols.add("Quantity");
           cols.add("DiscountRate");
           cols.add("Description");
           DetailSalesBill dt=new DetailSalesBill();
           DefaultTableModel dc=new DefaultTableModel(dt.lisdetailsalesbill(),cols)
                    {

            @Override
            public boolean isCellEditable(int row, int column) {
                return false;
            }
            
        }; 
        this.jTableeditsalesbill2.getTableHeader().setReorderingAllowed(false);
           jTableeditsalesbill2.setModel(dc);
        }
        catch(Exception ex)
        {
            System.out.println(ex);
        }
    }
       public void rfdtsb()
       {
           createpd();
           jTextFieldprice2.setText("");
           jTextFieldquantity2.setText("");
           jTextFielddcountrate2.setText("");
           jTextAreadescription.setText("");
       }
    private void jTablecontentMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTablecontentMouseClicked
        jButton2.setEnabled(true);
        jButton1.setEnabled(false);
        jComboBoxProductname.setEnabled(false);
        jButton3.setEnabled(true);
        jTabbedPane2.setVisible(true);
        jTabbedPane2.removeAll();
        jTabbedPane2.addTab("Detail Sales Bill",  jPanel97);
        JPanel pn=new JPanel();
         jTabbedPane2.addTab("Add Detail Sales Bill",  pn);
         JPanel pm=new JPanel();
         jTabbedPane2.addTab("New customer",  pm);
         Tableinformation1();
        
       Createdetailsalesbill();
       rfdtsb();
}//GEN-LAST:event_jTablecontentMouseClicked
        int i=8;
        int j=0;
        int count =0;
        int pages=2;
    private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton6ActionPerformed
       SalesBill sb=new SalesBill();
        jButton7.setEnabled(true);
       if(i<sb.geti())
       {
       Creattabledatabase1(i);
        i=i+4;
        j=j+4;
       }
          else
       {
           
           j=j+4;
           i=i-4;
          Creattabledatabase2(i);
          
          jButton6.setEnabled(false);
          System.out.println("i 2"+i);
          count++;
          }
       
       jLabel10.setText("Pages"+" "+pages);
       pages++;
      // sb.geti();
}//GEN-LAST:event_jButton6ActionPerformed
    
    private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton7ActionPerformed
       
       SalesBill sb=new SalesBill();
       Creattabledatabasepr(j);
       i=i-4;
       j=j-4; 
        if (j< 4)
        jButton7.setEnabled(false);
        //i=i+4;
        if(count !=0)
        {
            i=i+8;
        }
        count =0;
        jButton6.setEnabled(true);
        pages=pages-2;
        jLabel10.setText("Pages"+" "+pages);
        
        pages++;
    }//GEN-LAST:event_jButton7ActionPerformed
    public void Adddetailsalesbill()
    { 
        try
        {
            
        
           int billid= SalesBill.salesbill().getBillId();
           int productid=prdid();
           DetailSalesBill dt=new DetailSalesBill();
           dt.setBillId(billid);
           dt.setProductId(productid);
           dt.setPrice(Double.valueOf(this.jTextFieldprice.getText()));
           dt.setQuantity(Integer.valueOf(this.jTextFieldquantity.getText()));
           dt.setDiscountRate(Integer.valueOf(this.jTextFielddiscountrate.getText()));
           dt.setDescription(this.jTextAreadesription.getText());
           //System.out.println("proid"+productid);
             //billid=0;
           if(dt.Adddetailsalesbill())
           {
                 ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\change.png");
                    JOptionPane.showMessageDialog(null, "Press OK to continue", "Success", 0, iic);
           }
           else
           {
                ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\war.png");
                    JOptionPane.showMessageDialog(null, "Press OK to continue", "Failed", 0, iic);
           }
        }
        catch(Exception ex)
        {
            System.out.println(ex);
        }
      
    }
    public double gettotal()
    {
        double total=0;
        int dcr=Integer.valueOf( jTextFielddiscountrate.getText());
        double pr=Double.valueOf(jTextFieldprice.getText());
        int qt=Integer.valueOf(jTextFieldquantity.getText());
        if(jTextFieldprice.getText()==null && jTextFieldquantity.getText()==null && jTextFielddiscountrate.getText()==null)
        {
            total=0;
        }
                
        else if(dcr!=0)
            {
             total=Double.valueOf(pr-(pr*qt*Double.valueOf(dcr)/100));                           
            }
                else
                {
                    total=Double.valueOf(pr*qt);

                }
        return total;
    } 
    double total=0;
    public void rfadddetailsalesbill()
    {
        jTextFieldprice.setText(null);
        jTextFieldquantity.setText(null);
        jTextFielddiscountrate.setText(null);
        jTextAreadesription.setText(null);
    }
      public void updateproduct()
      {
          Product pr=new Product();
         // pr.setPrice(Double.valueOf(jTextFieldprice.getText()));
          pr.setProductName(jComboBoxProductname.getSelectedItem().toString());
          int qt=pr.getquantityproduct().getQuantily();
          System.out.println("qt"+qt);
          pr.setQuantily(qt-Integer.valueOf(jTextFieldquantity.getText()));         
          if(pr.updateproduct11())
          {
            try {
                ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\change.png");
                         JOptionPane.showMessageDialog(null,"Prouct Updated", "Success", 0, iic);
            } catch (IOException ex) {
                Logger.getLogger(JInternalFramePrchaseBill1.class.getName()).log(Level.SEVERE, null, ex);
            }
          }
          else
          {
            try {
                ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\war.png");
                         JOptionPane.showMessageDialog(null, "Press OK to continue", "Failed", 0, iic);
            } catch (IOException ex) {
                Logger.getLogger(JInternalFramePrchaseBill1.class.getName()).log(Level.SEVERE, null, ex);
            }
          }
              
      }
    private void jButton12ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton12ActionPerformed
        int count=0;
        Product pr=new Product();
        pr.setProductName(jComboBoxProductname.getSelectedItem().toString());
        int productid=prdid();
         int billid= SalesBill.salesbill().getBillId();
           DetailSalesBill dt=new DetailSalesBill();
           dt.setBillId(billid);
           vtdt=dt.Vectordetailsailbill();
           vtdt.size();
        if(jTextFieldprice.getText().equals(""))
        {
            jTextFieldprice.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
                     
        }
        else if(Check.isNumber1(jTextFieldprice.getText())==false)
            {
                jTextFieldprice.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
                jTextFieldprice.setText("Is number");
            }
        else if(jTextFieldquantity.getText().equals(""))
        {
            jTextFieldquantity.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
        } 
        else if(Check.isNumber(jTextFieldquantity.getText())==false)
         {
                jTextFieldquantity.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
                jTextFieldquantity.setText("Is number");
         }       
        else if(jTextFielddiscountrate.getText().equals(""))
        {
            jTextFielddiscountrate.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
        }   
         else if(Check.isNumber(jTextFielddiscountrate.getText())==false)
         {
                jTextFielddiscountrate.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
                jTextFielddiscountrate.setText("Is number");
         }
         else if(Integer.valueOf(jTextFieldquantity.getText())>pr.getquantityproduct().getQuantily())
         {
            try {
                ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\admin_bad_word_filter_configure.gif");
                JOptionPane.showMessageDialog(null, "so luong chi con"+pr.getquantityproduct().getQuantily(), "Failed", 0, iic);
            } catch (IOException ex) {
                Logger.getLogger(JInternalFrameSalesBill.class.getName()).log(Level.SEVERE, null, ex);
            }
         }
        else
        {
            for(DetailSalesBill dtt:vtdt)
           {
               if(productid==dtt.getProductId())
                  count++;
           }
            if(count==0)
            {
             Adddetailsalesbill();
              int i=4;
             Creattabledatabase1(i);
             total=total+ gettotal(); 
             Editsalesbill1();   
             Creattabledatabase1(i);
             updateproduct();
             rfadddetailsalesbill();
             jTabbedPane2.setVisible(false);
             }
            else
            {
                try {
                    ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\admin_bad_word_filter_configure.gif");
                       JOptionPane.showMessageDialog(null, "Has existed", "Failed", 0, iic);
                } catch (IOException ex) {
                    Logger.getLogger(JInternalFrameSalesBill.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
           
        }
}//GEN-LAST:event_jButton12ActionPerformed
    public void refeaddetail()
    {
       jTextFieldprice.setText(null);
       jTextFieldquantity.setText(null);
       jTextFielddiscountrate.setText(null);
       jTextAreadesription.setText(null);
    }
    private void jButton13ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton13ActionPerformed
        refeaddetail();
       // System.out.println(prdid());
}//GEN-LAST:event_jButton13ActionPerformed
    public void detailsalesbill()
    {
        String prname=jTableeditsalesbill2.getValueAt(jTableeditsalesbill2.getSelectedRow(), 0).toString();
        jComboBoxproductname22.setSelectedItem(prname);
    }
    public boolean  checknullsalesbill()
    {
        boolean check =true;
        try
        {
            jTextFieldbillname.getText().equals("");
        }
        catch(Exception ex)
        {
             check=false;       
        }
      return check; 
    }
    public void hire()
    {
        jTextFieldbillname.setEnabled(false);
        jComboBoxcustomername.setEnabled(false);
        jButton14.setEnabled(false);
        jComboBoxaccount.setEnabled(false);
        jCalendarCombobuilddate.setEnabled(false);
        jComboBoxst.setEnabled(false);
        jComboBoxunit.setEnabled(false);
    }
    public void unhire()
    {
         jTextFieldbillname.setEnabled(true);
        jComboBoxcustomername.setEnabled(true);
        jButton14.setEnabled(true);
        jComboBoxaccount.setEnabled(true);
        jCalendarCombobuilddate.setEnabled(true);
        jComboBoxst.setEnabled(true);
        jComboBoxunit.setEnabled(true);
    }
    
    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
        SalesBill s=new SalesBill();
        if(jTextFieldbillname.getText().equals(""))
        {
            jTextFieldbillname.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
        }
        else if((jComboBoxcustomername.getSelectedItem().toString()).equals("Select"))
        {
            jComboBoxcustomername.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
            
        }
          else if((jComboBoxaccount.getSelectedItem().toString()).equals("Select"))
        {
            jComboBoxaccount.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
            
        }    
         else if((jCalendarCombobuilddate.getSelectedItem().toString()).equals("Select"))
        {
            jCalendarCombobuilddate.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
            
        }  
         else if((jComboBoxst.getSelectedItem().toString()).equals("Select"))
        {
            jComboBoxst.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
            
        }      
       else if((jComboBoxunit.getSelectedItem().toString()).equals("Select"))
        {
            jComboBoxunit.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
            
        }     
       else if(s.geti()>4)
       {
           jButton6.setEnabled(true);
       }
         
       else if( Adsalesbill())
        {
         total=0;
       // Adsalesbill();
        int i=4;
        Creattabledatabase1(i);
        jComboBoxProductname.setEnabled(true);
         Createcbpd();
         jComboBoxProductname.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
        // rfsalesbill();
         jButton1.setEnabled(false);
         hire();
        }
    }//GEN-LAST:event_jButton1ActionPerformed
    public void getdiscountandprice()
    {
        Product pd=new Product();
        pd.setProductName(jComboBoxProductname.getSelectedItem().toString());
        jTextFieldprice.setText(String.valueOf(pd.getdiscountrateandpriceproduct().getPrice()));
        jTextFielddiscountrate.setText(String.valueOf(pd.getdiscountrateandpriceproduct().getDiscountRate()));
    }
    private void jComboBoxProductnameActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBoxProductnameActionPerformed
        jComboBoxProductname.setBorder(javax.swing.BorderFactory.createLineBorder(Color.gray));
        jTabbedPane2.setVisible(true);
        jTabbedPane2.removeAll();
        jTabbedPane2.addTab("Add Detail Sales Bill",  jPanel96);
        JPanel pn=new JPanel();
         jTabbedPane2.addTab("Detail Sales Bill",  pn);
         JPanel pm=new JPanel();
         jTabbedPane2.addTab("New customer",  pm);
         getdiscountandprice();
        
    }//GEN-LAST:event_jComboBoxProductnameActionPerformed

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
 
        Editsalesbill();
        //create rep database
        int i=4;
       Creattabledatabase1(i);
       jButton2.setEnabled(false);
       jButton3.setEnabled(false);
    }//GEN-LAST:event_jButton2ActionPerformed
    public void rfsalesbill()
    {
        try
        {
        jTextFieldbillname.setText(null);
        Createcb();
        Createcbad();
        Createcbpd();
        jCalendarCombobuilddate.setSelectedItem("Select");
        jComboBoxst.setSelectedItem("Select");
        jComboBoxunit.setSelectedItem("Select");
        jComboBoxProductname.setSelectedItem("Select");
        jComboBoxProductname.setEnabled(false);
         jButton14.setEnabled(true);
        }
        catch(Exception ex)
        {
            System.out.println(ex);
        }
    }
    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed
        total=0;
        jButton1.setEnabled(true);
        refeaddetail();
        rfsalesbill();
        unhire();
        jTabbedPane2.setVisible(false);
        jButton2.setEnabled(false);
        jButton3.setEnabled(false);
    }//GEN-LAST:event_jButton4ActionPerformed

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
       SalesBill sb=new SalesBill();
        int op = JOptionPane.showConfirmDialog(null, "Are you sure to delete ?", "Message", JOptionPane.OK_CANCEL_OPTION);
       if(op==JOptionPane.OK_OPTION && sb.geti()>4)
       {
           if(sb.geti()>4)
           {
            Deletesalesbill();
           jButton3.setEnabled(false);
           jButton2.setEnabled(false);
            int i=4;
            Creattabledatabase1(i);
            jButton6.setEnabled(true);
           }
           else
           {
               jButton6.setEnabled(false);
               Creattabledatabase22(sb.geti());
              
           }
       }
       
    }//GEN-LAST:event_jButton3ActionPerformed
    public void tableinformation()
    {
        try
        {
            String productname2=this.jTableeditsalesbill2.getValueAt(jTableeditsalesbill2.getSelectedRow(), 0).toString();
            String price=this.jTableeditsalesbill2.getValueAt(jTableeditsalesbill2.getSelectedRow(), 1).toString();
            String quantity=this.jTableeditsalesbill2.getValueAt(jTableeditsalesbill2.getSelectedRow(), 2).toString();
            String descountrate=this.jTableeditsalesbill2.getValueAt(jTableeditsalesbill2.getSelectedRow(), 3).toString();
            String description=this.jTableeditsalesbill2.getValueAt(jTableeditsalesbill2.getSelectedRow(), 4).toString();
            this.jComboBoxproductname22.setSelectedItem(productname2);
            this.jTextFieldprice2.setText(price);
            this.jTextFieldquantity2.setText(quantity);
            this.jTextFielddcountrate2.setText(descountrate);
            this.jTextAreadescription.setText(description);
            
        }
        catch(Exception ex)
        {
            System.out.println(ex);
        }
    }
    private void jCalendarCombobuilddateActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jCalendarCombobuilddateActionPerformed
    jCalendarCombobuilddate.setBorder(javax.swing.BorderFactory.createLineBorder(Color.gray));
    }//GEN-LAST:event_jCalendarCombobuilddateActionPerformed

    private void jButton15ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton15ActionPerformed
//        Deletedetailsalesbill();
//        Createdetailsalesbill();
}//GEN-LAST:event_jButton15ActionPerformed

    private void jTextFieldbillnameActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jTextFieldbillnameActionPerformed

    }//GEN-LAST:event_jTextFieldbillnameActionPerformed

    private void jTextFieldbillnameMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTextFieldbillnameMouseClicked
    jTextFieldbillname.setBorder(javax.swing.BorderFactory.createLineBorder(Color.GRAY));       
    }//GEN-LAST:event_jTextFieldbillnameMouseClicked

    private void jComboBoxcustomernameActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBoxcustomernameActionPerformed
         jComboBoxcustomername.setBorder(javax.swing.BorderFactory.createLineBorder(Color.gray));
        // jButton14.setEnabled(false);
    }//GEN-LAST:event_jComboBoxcustomernameActionPerformed

    private void jComboBoxaccountActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBoxaccountActionPerformed
      jComboBoxaccount.setBorder(javax.swing.BorderFactory.createLineBorder(Color.gray));
    }//GEN-LAST:event_jComboBoxaccountActionPerformed

    private void jComboBoxstActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBoxstActionPerformed
        jComboBoxst.setBorder(javax.swing.BorderFactory.createLineBorder(Color.gray));
    }//GEN-LAST:event_jComboBoxstActionPerformed

    private void jComboBoxunitActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBoxunitActionPerformed
       jComboBoxunit.setBorder(javax.swing.BorderFactory.createLineBorder(Color.gray));
    }//GEN-LAST:event_jComboBoxunitActionPerformed

    private void jTextFieldpriceMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTextFieldpriceMouseClicked
        jTextFieldprice.setBorder(javax.swing.BorderFactory.createLineBorder(Color.gray));
    }//GEN-LAST:event_jTextFieldpriceMouseClicked

    private void jTextFieldquantityMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTextFieldquantityMouseClicked
       jTextFieldquantity.setBorder(javax.swing.BorderFactory.createLineBorder(Color.gray));
    }//GEN-LAST:event_jTextFieldquantityMouseClicked

    private void jTextFielddiscountrateActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jTextFielddiscountrateActionPerformed
       jTextFielddiscountrate.setBorder(javax.swing.BorderFactory.createLineBorder(Color.gray));
    }//GEN-LAST:event_jTextFielddiscountrateActionPerformed

    private void jTextFielddiscountrateMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTextFielddiscountrateMouseClicked
        jTextFielddiscountrate.setBorder(javax.swing.BorderFactory.createLineBorder(Color.gray));
    }//GEN-LAST:event_jTextFielddiscountrateMouseClicked

    private void jButton14ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton14ActionPerformed
        jComboBoxcustomername.setEnabled(false);
         jTabbedPane2.setVisible(true);
        jTabbedPane2.removeAll();
        jTabbedPane2.addTab("New customew",  jPanel161);
        JPanel pn=new JPanel();
         jTabbedPane2.addTab("Detail Sales Bill",  pn);
         JPanel pm=new JPanel();
         jTabbedPane2.addTab("Add Detail Sales Bill",  pm);
           rfctmersalesbill() ;
    }//GEN-LAST:event_jButton14ActionPerformed
    public void Addctmsalesbill()
    {
       Customer ct=new Customer();
       ct.setCustomername(jTextFieldctmname.getText());
       ct.setAddress(jTextFieldadress.getText());
       ct.setPhone(jTextFieldphone.getText());
       ct.setEmail(jTextFieldemail.getText());
       ct.setGender(jComboBoxgender.getSelectedItem().toString());
       ct.setCustomertype(jComboBoxcustmtype.getSelectedItem().toString());
       if(ct.Insert_Customer())
       {
            try {
                ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\change.png");
                         JOptionPane.showMessageDialog(null, "Press OK to continue", "Success", 0, iic);
            } catch (IOException ex) {
                Logger.getLogger(JInternalFrameSalesBill.class.getName()).log(Level.SEVERE, null, ex);
            }
       }
       else
       {
            try {
                ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\war.png");
                         JOptionPane.showMessageDialog(null, "Press OK to continue", "Failed", 0, iic);
            } catch (IOException ex) {
                Logger.getLogger(JInternalFrameSalesBill.class.getName()).log(Level.SEVERE, null, ex);
            }
       }
    }    public void rfctmersalesbill()
    {
        jTextFieldctmname.setText(null);
        jTextFieldadress.setText(null);
        jTextFieldphone.setText(null);
        jTextFieldemail.setText(null);
        jComboBoxgender.setSelectedItem("Select");
        jComboBoxcustmtype.setSelectedItem("Select");
        jTextAreadription.setText(null);
    }
    private void jTextFieldctmnameMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTextFieldctmnameMouseClicked
   jTextFieldctmname.setBorder(javax.swing.BorderFactory.createLineBorder(Color.GRAY));       
   jButton17.setEnabled(true);
    }//GEN-LAST:event_jTextFieldctmnameMouseClicked

    private void jTextFieldadressMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTextFieldadressMouseClicked
      jTextFieldadress.setBorder(javax.swing.BorderFactory.createLineBorder(Color.GRAY));       
    }//GEN-LAST:event_jTextFieldadressMouseClicked

    private void jTextFieldphoneMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTextFieldphoneMouseClicked
       jTextFieldphone.setBorder(javax.swing.BorderFactory.createLineBorder(Color.GRAY));       
    }//GEN-LAST:event_jTextFieldphoneMouseClicked

    private void jTextFieldemailMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTextFieldemailMouseClicked
       jTextFieldemail.setBorder(javax.swing.BorderFactory.createLineBorder(Color.GRAY));       
    }//GEN-LAST:event_jTextFieldemailMouseClicked

    private void jComboBoxgenderActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBoxgenderActionPerformed
     jComboBoxgender.setBorder(javax.swing.BorderFactory.createLineBorder(Color.GRAY));       
    }//GEN-LAST:event_jComboBoxgenderActionPerformed

    private void jComboBoxcustmtypeActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBoxcustmtypeActionPerformed
     jComboBoxcustmtype.setBorder(javax.swing.BorderFactory.createLineBorder(Color.GRAY)); 
    }//GEN-LAST:event_jComboBoxcustmtypeActionPerformed
     public void Searchsalebill(String s)
    {
        Vector<Object> cols=new Vector<Object>();
        cols.add("BillId");
        cols.add("Bill Name");
        cols.add("Customer Name");
        cols.add("AccountName");
        cols.add("BuildDate");
        cols.add("State");
        cols.add("Unit");
        cols.add("TotalCost");
        SalesBill sb=new SalesBill();
        DefaultTableModel dmn=new DefaultTableModel(sb.Searchsalesbill(s),cols){

            @Override
            public boolean isCellEditable(int row, int column) {
                return false;
            }
            
        }; 
        this.jTablesearchsalesbill.setModel(dmn);
         this.jTablesearchsalesbill.getTableHeader().setReorderingAllowed(false);
        
    }
         public void Searwithctm(String s)
    {
        Vector<Object> cols=new Vector<Object>();
        cols.add("BillId");
        cols.add("Bill Name");
        cols.add("Customer Name");
        cols.add("AccountName");
        cols.add("BuildDate");
        cols.add("State");
        cols.add("Unit");
        cols.add("TotalCost");
        SalesBill sb=new SalesBill();
        DefaultTableModel dmn=new DefaultTableModel(sb.Searchwithcustomer(s),cols){

            @Override
            public boolean isCellEditable(int row, int column) {
                return false;
            }
            
        }; 
        this.jTablesearchsalesbill.setModel(dmn);
         this.jTablesearchsalesbill.getTableHeader().setReorderingAllowed(false);
        
    }
           public void Searwithctmandsb(String s1, String s2)
    {
        Vector<Object> cols=new Vector<Object>();
        cols.add("BillId");
        cols.add("Bill Name");
        cols.add("Customer Name");
        cols.add("AccountName");
        cols.add("BuildDate");
        cols.add("State");
        cols.add("Unit");
        cols.add("TotalCost");
        SalesBill sb=new SalesBill();
        DefaultTableModel dmn=new DefaultTableModel(sb.Searchwithcustomerandbillname(s1, s2),cols){

            @Override
            public boolean isCellEditable(int row, int column) {
                return false;
            }
            
        }; 
        this.jTablesearchsalesbill.getTableHeader().setReorderingAllowed(false);
        this.jTablesearchsalesbill.setModel(dmn);
         
        
    }
    private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton5ActionPerformed
        if(jCheckBoxsearchbillname.isSelected() && jCheckBoxsearchctomername.isSelected()&&jTextFieldsearchbillname.getText().equals("") && jComboBoxctmsearch.getSelectedItem().toString().equals("Select"))
        {
            jTextFieldsearchbillname.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
            jTextFieldsearchbillname.setText("Not null");
            jComboBoxctmsearch.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
        }
         else if(jCheckBoxsearchbillname.isSelected() && jTextFieldsearchbillname.getText().equals(""))
        {
            jTextFieldsearchbillname.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
            jTextFieldsearchbillname.setText("Not null");
        }
        else if(jCheckBoxsearchctomername.isSelected()&&jComboBoxctmsearch.getSelectedItem().toString().equals("Select"))
        {
           jComboBoxctmsearch.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
            
        }
       else if(jCheckBoxsearchbillname.isSelected()&&jCheckBoxsearchctomername.isSelected())
       {
           jLabelero.setText("");
           Searwithctmandsb(jTextFieldsearchbillname.getText(),jComboBoxctmsearch.getSelectedItem().toString());
       }
       
       else if(jCheckBoxsearchbillname.isSelected())
       {
           jLabelero.setText("");
           Searchsalebill(jTextFieldsearchbillname.getText());
       }
         else if(jCheckBoxsearchctomername.isSelected())
       {
           jLabelero.setText("");
           Searwithctm(jComboBoxctmsearch.getSelectedItem().toString());
       }     
       else
         {
            jLabelero.setText("Select Search Type................");
         }
    }//GEN-LAST:event_jButton5ActionPerformed

    private void jCheckBoxsearchctomernameMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jCheckBoxsearchctomernameMouseClicked
     jComboBoxctmsearch.setEnabled(true);
      jButton5.setEnabled(true);
    }//GEN-LAST:event_jCheckBoxsearchctomernameMouseClicked

    private void jCheckBoxsearchbillnameMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jCheckBoxsearchbillnameMouseClicked
  
        jButton5.setEnabled(true);
    }//GEN-LAST:event_jCheckBoxsearchbillnameMouseClicked

    private void jTextFieldsearchbillnameMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTextFieldsearchbillnameMouseClicked
        jTextFieldsearchbillname.setText("");
        jTextFieldsearchbillname.setBorder(javax.swing.BorderFactory.createLineBorder(Color.GRAY));       
    }//GEN-LAST:event_jTextFieldsearchbillnameMouseClicked

    private void jComboBoxctmsearchActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBoxctmsearchActionPerformed
    jComboBoxctmsearch.setBorder(javax.swing.BorderFactory.createLineBorder(Color.gray));
    }//GEN-LAST:event_jComboBoxctmsearchActionPerformed

    private void jTableeditsalesbill2MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTableeditsalesbill2MouseClicked
        //jButton16.setEnabled(true);
        tableinformation();
}//GEN-LAST:event_jTableeditsalesbill2MouseClicked

    private void jButton18ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton18ActionPerformed
        rfctmersalesbill() ;
        jButton17.setEnabled(true);
        
    }//GEN-LAST:event_jButton18ActionPerformed

    private void jButton17ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton17ActionPerformed
        if(jTextFieldctmname.getText().equals(""))
        {
             jTextFieldctmname.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
        }
        else if(jTextFieldadress.getText().equals(""))
       {
           jTextFieldadress.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
       }
          else if(jTextFieldphone.getText().equals(""))
       {
           jTextFieldphone.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
       }
     else if(jTextFieldemail.getText().equals(""))
       {
           jTextFieldemail.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
       }
       else if(!Check.Emailinvalid(jTextFieldemail.getText()))
       {
           jTextFieldemail.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
           jTextFieldemail.setText("Type Email....");
       }       
      else if(jComboBoxgender.getSelectedItem().toString().equals("Select"))
       {
           jComboBoxgender.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
       }
      else if(jComboBoxcustmtype.getSelectedItem().toString().equals("Select"))
       {
           jComboBoxcustmtype.setBorder(javax.swing.BorderFactory.createLineBorder(Color.RED));
       }      
      else
       {
        Addctmsalesbill();
         Createcb();
         jButton17.setEnabled(false);
         jComboBoxcustomername.setEnabled(true);
        jTabbedPane2.setVisible(false);
       }

    }//GEN-LAST:event_jButton17ActionPerformed
    public double  Updatetotal()
    {
        double total=0;
        double price=Double.valueOf(jTableeditsalesbill2.getValueAt(i, 2).toString());
        int qt=Integer.valueOf(jTableeditsalesbill2.getValueAt(i, 3).toString());
        int dc= Integer.valueOf(jTableeditsalesbill2.getValueAt(i, 4).toString());
       for(int i=1; i<jTableeditsalesbill2.getRowCount(); i++)
       {
           if(dc==0)
           {
               total=price*qt;
           }
           else
           {
               total=price-(price*qt*dc/100);
           }
           total=total+total;
       }
           return total;
    }    
//    public void Deletedetailsalesbill()
//    {
//        try
//        {
//           DetailSalesBill dts=new DetailSalesBill();
//           dts.setProductId(Integer.valueOf(jTableeditsalesbill2.getValueAt(jTableeditsalesbill2.getSelectedRow(), 0).toString()));
//           if(dts.Deletedetailsailbill())
//           {
////                ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\delete_edit_trash_icon.png");
////                JOptionPane.showMessageDialog(null, "Press OK to continue", "Success", 0, iic);
//           }
//           else
//           {
////               ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\canhbao.png");
////                        JOptionPane.showMessageDialog(null, "Press Ok to continue", "Failed", 0, iic);
//           }
//        }
//        catch(Exception ex)
//        {
//            System.out.println(ex);
//        }
//    }   
    public void Editdetailsalesbill()
    {
        try
        {
            DetailSalesBill dtsb=new DetailSalesBill();
            int billid=Integer.valueOf(jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 0).toString());
            dtsb.setBillId(billid);
            dtsb.setDescription(jTextAreadescription.getText());
            dtsb.setDiscountRate(Integer.valueOf(jTextFielddcountrate2.getText()));
            dtsb.setPrice(Double.valueOf(jTextFieldprice2.getText()));
            dtsb.setQuantity(Integer.valueOf(jTextFieldquantity2.getText()));
            dtsb.setProductId(prdid1());
            //.out.print(billid+" "+" "+prdid1());
            if(dtsb.Editdetailsalesbill())
            {
                JOptionPane.showMessageDialog(null, "Success");
            }
            else
            {
                JOptionPane.showMessageDialog(null, "Failed"); 
            }
        }
        catch(Exception ex)
        {
            System.out.println(ex);
        }
    }
    public void Editsalesbill()
    {
         try
        {
        SalesBill sb=new SalesBill();
        sb.setBillName(this.jTextFieldbillname.getText());
        int customerid=ctl.get(jComboBoxcustomername.getSelectedIndex()).getCustomerid() ;
        sb.setCustomerId(customerid);
        int accountid=adl.get(jComboBoxaccount.getSelectedIndex()).getAccountid();
        sb.setAccountId(accountid);
        sb.setBuildDate(jCalendarCombobuilddate.getDate());
            
        sb.setState(jComboBoxst.getSelectedItem().toString());
        sb.setUnit(jComboBoxunit.getSelectedItem().toString());
        sb.setTotalCost(0);
        System.out.println();
        int billid=Integer.valueOf(jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 0).toString());
        sb.setBillId(billid);
        if(sb.Updatesalesbill())
        {
            ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\edit_male_user_icon.png");
            JOptionPane.showMessageDialog(null, "Press OK to continue", "Success", 0, iic);
        }
        else
        {
              ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\canhbao.png");
                    JOptionPane.showMessageDialog(null, "Press OK to continue", "Failed", 0, iic);
        }
        }
        catch(Exception ex)
        {
            System.out.println(ex);
        }
         
    }

   public void Editsalesbill1()
    {
         try
        {
        SalesBill sb=new SalesBill();
        sb.setTotalCost(total);
        System.out.println();
        int billid= SalesBill.salesbill().getBillId();
        sb.setBillId(billid);
       sb.Updatesalesbill1();
        }
        catch(Exception ex)
        {
            System.out.println(ex);
        }
         
    }
      public void Editotal()
    {
         try
        {
        SalesBill sb=new SalesBill();
        sb.setTotalCost(total);
        System.out.println();
        int billid= SalesBill.salesbill().getBillId();
        sb.setBillId(billid);
        if(sb.Updatesalesbill1())
        {
            JOptionPane.showMessageDialog(null, "Success");
        }
        else
        {
            JOptionPane.showMessageDialog(null, "Failed");
        }
        }
        catch(Exception ex)
        {
            System.out.println(ex);
        }
         
    }
   public int Countrowtable()
   {
       int count =0;
       count=jTableeditsalesbill2.getRowCount();
       return count;
   }
  
    public void Deletesalesbill()
    {
         SalesBill sb=new SalesBill();
        sb.setBillId(Integer.valueOf(jTablecontent.getValueAt(jTablecontent.getSelectedRow(), 0).toString()));
        System.out.println(Countrowtable());
        if( Countrowtable()==0)
        {
            if(sb.Deletesalesbill())
            {
                try {
                    ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\delete_edit_trash_icon.png");
                    JOptionPane.showMessageDialog(null, "Press OK to continue", "Success", 0, iic);
                } catch (IOException ex) {
                    Logger.getLogger(JInternalFrameSalesBill.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
            else
            {
                try {
                    ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\canhbao.png");
                            JOptionPane.showMessageDialog(null, "Press OK to continue", "Failed", 0, iic);
                } catch (IOException ex) {
                    Logger.getLogger(JInternalFrameSalesBill.class.getName()).log(Level.SEVERE, null, ex);
                }

            }
        }
        else
        {
            try {
                ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\canhbao.png");
                                JOptionPane.showMessageDialog(null, "DetailSalesBill clear the board before", "Failed", 0, iic);
            } catch (IOException ex) {
                Logger.getLogger(JInternalFrameSalesBill.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    }   
    public boolean  Adsalesbill()
    {
        boolean rs=true;
        try {
            SalesBill sb=new SalesBill();
            sb.setBillName(this.jTextFieldbillname.getText());
            int customerid=ctl.get(jComboBoxcustomername.getSelectedIndex()).getCustomerid() ;
            sb.setCustomerId(customerid);
            int accountid=adl.get(jComboBoxaccount.getSelectedIndex()).getAccountid();
            sb.setAccountId(accountid);
            
            sb.setBuildDate(jCalendarCombobuilddate.getDate());
            
            sb.setState(jComboBoxst.getSelectedItem().toString());
            sb.setUnit(jComboBoxunit.getSelectedItem().toString());
            sb.setTotalCost(0);
            if(sb.Addsalesbill()) {
                try {
                    ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\change.png");
                    JOptionPane.showMessageDialog(null, "Press OK to continue", "Success", 0, iic);
                } catch (Exception e) {
                    System.out.println(e);
                }
                
            }
            else
            {
                 ImageIcon iic = new ImageIcon(f.getCanonicalPath()+"\\src\\Images\\war.png");
                    JOptionPane.showMessageDialog(null, "Press OK to continue", "Failed", 0, iic);
            }
            
        }
        
        catch(Exception ex) {
            rs=false;
            System.out.println(ex);
        }
        return rs;
    }
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.ButtonGroup buttonGroup1;
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton10;
    private javax.swing.JButton jButton11;
    private javax.swing.JButton jButton12;
    private javax.swing.JButton jButton13;
    private javax.swing.JButton jButton14;
    private javax.swing.JButton jButton15;
    private javax.swing.JButton jButton17;
    private javax.swing.JButton jButton18;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton4;
    private javax.swing.JButton jButton5;
    private javax.swing.JButton jButton6;
    private javax.swing.JButton jButton7;
    private javax.swing.JButton jButton8;
    private javax.swing.JButton jButton9;
    private org.freixas.jcalendar.JCalendarCombo jCalendarCombobuilddate;
    private javax.swing.JCheckBox jCheckBoxsearchbillname;
    private javax.swing.JCheckBox jCheckBoxsearchctomername;
    private javax.swing.JComboBox jComboBox1;
    private javax.swing.JComboBox jComboBoxProductname;
    private javax.swing.JComboBox jComboBoxaccount;
    private javax.swing.JComboBox jComboBoxctmsearch;
    private javax.swing.JComboBox jComboBoxcustmtype;
    private javax.swing.JComboBox jComboBoxcustomername;
    private javax.swing.JComboBox jComboBoxgender;
    private javax.swing.JComboBox jComboBoxproductname22;
    private javax.swing.JComboBox jComboBoxst;
    private javax.swing.JComboBox jComboBoxunit;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel17;
    private javax.swing.JLabel jLabel18;
    private javax.swing.JLabel jLabel19;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel20;
    private javax.swing.JLabel jLabel21;
    private javax.swing.JLabel jLabel22;
    private javax.swing.JLabel jLabel23;
    private javax.swing.JLabel jLabel24;
    private javax.swing.JLabel jLabel26;
    private javax.swing.JLabel jLabel27;
    private javax.swing.JLabel jLabel28;
    private javax.swing.JLabel jLabel29;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel30;
    private javax.swing.JLabel jLabel31;
    private javax.swing.JLabel jLabel32;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JLabel jLabelero;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel10;
    private javax.swing.JPanel jPanel100;
    private javax.swing.JPanel jPanel101;
    private javax.swing.JPanel jPanel102;
    private javax.swing.JPanel jPanel103;
    private javax.swing.JPanel jPanel104;
    private javax.swing.JPanel jPanel105;
    private javax.swing.JPanel jPanel106;
    private javax.swing.JPanel jPanel107;
    private javax.swing.JPanel jPanel108;
    private javax.swing.JPanel jPanel109;
    private javax.swing.JPanel jPanel11;
    private javax.swing.JPanel jPanel110;
    private javax.swing.JPanel jPanel111;
    private javax.swing.JPanel jPanel112;
    private javax.swing.JPanel jPanel113;
    private javax.swing.JPanel jPanel114;
    private javax.swing.JPanel jPanel115;
    private javax.swing.JPanel jPanel116;
    private javax.swing.JPanel jPanel117;
    private javax.swing.JPanel jPanel118;
    private javax.swing.JPanel jPanel119;
    private javax.swing.JPanel jPanel12;
    private javax.swing.JPanel jPanel120;
    private javax.swing.JPanel jPanel121;
    private javax.swing.JPanel jPanel122;
    private javax.swing.JPanel jPanel123;
    private javax.swing.JPanel jPanel124;
    private javax.swing.JPanel jPanel125;
    private javax.swing.JPanel jPanel126;
    private javax.swing.JPanel jPanel127;
    private javax.swing.JPanel jPanel128;
    private javax.swing.JPanel jPanel129;
    private javax.swing.JPanel jPanel13;
    private javax.swing.JPanel jPanel130;
    private javax.swing.JPanel jPanel131;
    private javax.swing.JPanel jPanel132;
    private javax.swing.JPanel jPanel133;
    private javax.swing.JPanel jPanel134;
    private javax.swing.JPanel jPanel135;
    private javax.swing.JPanel jPanel136;
    private javax.swing.JPanel jPanel137;
    private javax.swing.JPanel jPanel138;
    private javax.swing.JPanel jPanel139;
    private javax.swing.JPanel jPanel14;
    private javax.swing.JPanel jPanel140;
    private javax.swing.JPanel jPanel141;
    private javax.swing.JPanel jPanel142;
    private javax.swing.JPanel jPanel143;
    private javax.swing.JPanel jPanel144;
    private javax.swing.JPanel jPanel145;
    private javax.swing.JPanel jPanel146;
    private javax.swing.JPanel jPanel147;
    private javax.swing.JPanel jPanel148;
    private javax.swing.JPanel jPanel149;
    private javax.swing.JPanel jPanel15;
    private javax.swing.JPanel jPanel153;
    private javax.swing.JPanel jPanel159;
    private javax.swing.JPanel jPanel16;
    private javax.swing.JPanel jPanel160;
    private javax.swing.JPanel jPanel161;
    private javax.swing.JPanel jPanel162;
    private javax.swing.JPanel jPanel163;
    private javax.swing.JPanel jPanel164;
    private javax.swing.JPanel jPanel165;
    private javax.swing.JPanel jPanel166;
    private javax.swing.JPanel jPanel167;
    private javax.swing.JPanel jPanel168;
    private javax.swing.JPanel jPanel169;
    private javax.swing.JPanel jPanel17;
    private javax.swing.JPanel jPanel170;
    private javax.swing.JPanel jPanel171;
    private javax.swing.JPanel jPanel172;
    private javax.swing.JPanel jPanel173;
    private javax.swing.JPanel jPanel174;
    private javax.swing.JPanel jPanel175;
    private javax.swing.JPanel jPanel176;
    private javax.swing.JPanel jPanel177;
    private javax.swing.JPanel jPanel178;
    private javax.swing.JPanel jPanel179;
    private javax.swing.JPanel jPanel18;
    private javax.swing.JPanel jPanel180;
    private javax.swing.JPanel jPanel181;
    private javax.swing.JPanel jPanel182;
    private javax.swing.JPanel jPanel183;
    private javax.swing.JPanel jPanel184;
    private javax.swing.JPanel jPanel185;
    private javax.swing.JPanel jPanel186;
    private javax.swing.JPanel jPanel187;
    private javax.swing.JPanel jPanel19;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel20;
    private javax.swing.JPanel jPanel21;
    private javax.swing.JPanel jPanel22;
    private javax.swing.JPanel jPanel23;
    private javax.swing.JPanel jPanel24;
    private javax.swing.JPanel jPanel25;
    private javax.swing.JPanel jPanel26;
    private javax.swing.JPanel jPanel27;
    private javax.swing.JPanel jPanel28;
    private javax.swing.JPanel jPanel29;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel30;
    private javax.swing.JPanel jPanel31;
    private javax.swing.JPanel jPanel32;
    private javax.swing.JPanel jPanel33;
    private javax.swing.JPanel jPanel34;
    private javax.swing.JPanel jPanel35;
    private javax.swing.JPanel jPanel36;
    private javax.swing.JPanel jPanel37;
    private javax.swing.JPanel jPanel38;
    private javax.swing.JPanel jPanel39;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JPanel jPanel40;
    private javax.swing.JPanel jPanel41;
    private javax.swing.JPanel jPanel42;
    private javax.swing.JPanel jPanel43;
    private javax.swing.JPanel jPanel44;
    private javax.swing.JPanel jPanel45;
    private javax.swing.JPanel jPanel46;
    private javax.swing.JPanel jPanel47;
    private javax.swing.JPanel jPanel48;
    private javax.swing.JPanel jPanel49;
    private javax.swing.JPanel jPanel5;
    private javax.swing.JPanel jPanel50;
    private javax.swing.JPanel jPanel51;
    private javax.swing.JPanel jPanel52;
    private javax.swing.JPanel jPanel53;
    private javax.swing.JPanel jPanel54;
    private javax.swing.JPanel jPanel55;
    private javax.swing.JPanel jPanel56;
    private javax.swing.JPanel jPanel57;
    private javax.swing.JPanel jPanel58;
    private javax.swing.JPanel jPanel59;
    private javax.swing.JPanel jPanel6;
    private javax.swing.JPanel jPanel60;
    private javax.swing.JPanel jPanel61;
    private javax.swing.JPanel jPanel62;
    private javax.swing.JPanel jPanel63;
    private javax.swing.JPanel jPanel64;
    private javax.swing.JPanel jPanel65;
    private javax.swing.JPanel jPanel66;
    private javax.swing.JPanel jPanel67;
    private javax.swing.JPanel jPanel68;
    private javax.swing.JPanel jPanel69;
    private javax.swing.JPanel jPanel7;
    private javax.swing.JPanel jPanel70;
    private javax.swing.JPanel jPanel71;
    private javax.swing.JPanel jPanel72;
    private javax.swing.JPanel jPanel73;
    private javax.swing.JPanel jPanel74;
    private javax.swing.JPanel jPanel75;
    private javax.swing.JPanel jPanel76;
    private javax.swing.JPanel jPanel77;
    private javax.swing.JPanel jPanel78;
    private javax.swing.JPanel jPanel79;
    private javax.swing.JPanel jPanel8;
    private javax.swing.JPanel jPanel80;
    private javax.swing.JPanel jPanel81;
    private javax.swing.JPanel jPanel82;
    private javax.swing.JPanel jPanel83;
    private javax.swing.JPanel jPanel84;
    private javax.swing.JPanel jPanel85;
    private javax.swing.JPanel jPanel86;
    private javax.swing.JPanel jPanel87;
    private javax.swing.JPanel jPanel88;
    private javax.swing.JPanel jPanel89;
    private javax.swing.JPanel jPanel9;
    private javax.swing.JPanel jPanel90;
    private javax.swing.JPanel jPanel91;
    private javax.swing.JPanel jPanel92;
    private javax.swing.JPanel jPanel93;
    private javax.swing.JPanel jPanel94;
    private javax.swing.JPanel jPanel95;
    private javax.swing.JPanel jPanel96;
    private javax.swing.JPanel jPanel97;
    private javax.swing.JPanel jPanel98;
    private javax.swing.JPanel jPanel99;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JScrollPane jScrollPane4;
    private javax.swing.JScrollPane jScrollPane5;
    private javax.swing.JScrollPane jScrollPane6;
    private javax.swing.JTabbedPane jTabbedPane1;
    private javax.swing.JTabbedPane jTabbedPane2;
    private javax.swing.JTable jTablecontent;
    private javax.swing.JTable jTableeditsalesbill2;
    private javax.swing.JTable jTablesearchsalesbill;
    private javax.swing.JTextArea jTextAreadescription;
    private javax.swing.JTextArea jTextAreadesription;
    private javax.swing.JTextArea jTextAreadription;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JTextField jTextField6;
    private javax.swing.JTextField jTextField7;
    private javax.swing.JTextField jTextFieldadress;
    private javax.swing.JTextField jTextFieldbillname;
    private javax.swing.JTextField jTextFieldctmname;
    private javax.swing.JTextField jTextFielddcountrate2;
    private javax.swing.JTextField jTextFielddiscountrate;
    private javax.swing.JTextField jTextFieldemail;
    private javax.swing.JTextField jTextFieldphone;
    private javax.swing.JTextField jTextFieldprice;
    private javax.swing.JTextField jTextFieldprice2;
    private javax.swing.JTextField jTextFieldquantity;
    private javax.swing.JTextField jTextFieldquantity2;
    private javax.swing.JTextField jTextFieldsearchbillname;
    // End of variables declaration//GEN-END:variables
}
